pay

i have to work out pay for many people on an hourly rate, up to 3 people over 3 job sites or 2 on 2 sites etc so have employee name , rate of pay and hours in h,i, and j colums and need to total for each day for each person (somtimes one person will do 2 jobs in 2 location. i have tried sum if...

Iv'e got a problen, with that formula I tried 0.40*100 and 0.60*100 but when i had in one group 1 person he will need to pay it all and its not correct.. Read in the picture. [/URL][/IMG]

trying to make a sheet that lists the hours of the day down column A, and the days across row 1, object is to mark each cell with one of three persons names. my Dad has Alzheimer's disease so we have 24/7 care givers/helpers and there a three different ladies and I need to keep track of their...

Hi Everyone, I've encountered a bit of a problem and would love some help with some coding & VBA . I have a personal finance budget and I usually go through different months (cell F2 in overview sheet which I have since defined & named as "Period" ) to check things. This is a drop-down list...

Scenario is, you have a long list of employee numbers (Col B for example) and against each employee number is a payment figure (Col C) and a Department (Col D). What we want to do is count the number of employee's who have an average pay that falls into various brackets and lie within one of...

I have two sheets - one with variable data split out by days: <tbody> Day Number 1 2 3 1 2 3 Date 01/11/2017 02/11/2017 03/11/2017 etc etc 01/12/2017 02/12/2017 03/12/2018 New Customers 1 5 10 2 4 6 </tbody> Each new customer will pay by direct debit the...

Good day all! i am a cable installer and when I process my work per job I enter in a code which them represents my pay. I also get paid at a percentage so need to be able to adjust the total pay based on my percentage. i HAD a functioning worksheet that did all of this but my laptop was...

does anyone have a formula to help calculate UK redundancy pay rules are as follows: -0.5 weeks pay for each full year under 22 -1 week pay for each full year they were 22 or older but under 41 -1.5 week pay for each full year they were 41 or older -length of service capped at 20 years -weekly...

Hi, I couldn't find the answer to this sorry if it was posted already: I have a timesheet that I would like to autofill the payperiod end date once the pay period begin date is plugged in, BUT if the pay period begin date is left blank I would like this cell to also be left blank(currently it...

Hi there all experts, I have new 2018 calendar that I would like to highlight by Conditional Formatting. I would like to highlight each date in bold red (I know that this is irrelevant to my question). It is a 4 x 3 month calendar Jan Feb Mar Apr May...

Hello, I am in charge of the tracking of Vacation time and I am having a really difficult time creating a formula. As I am not excel proficient. I would appreciate any help (: Our Payroll works as follows: PAY FREQUENCY -- 2 Times a month (on the 15th & Last Day of the month) 20 Days per...

I have a budget and I have pay period dates set up in say.... A1 is a set date, 01/13/2017 (first pay period for the year). I then have another cell, A20 with =A1+14 which gives me the next pay date and so forth and so forth along the months across sheets. Works great, well until you get...

Can someone share or point me in the direction of a spreadsheet template where I can enter in my bills due and figure out how much in expense versus income for the bi weekly pay periods? any ideas would be helpful as well.

Not sure if my title is exactly what I'm looking for but what I'm trying to do is lookup a value based on two criteria. The best way to show you what I'm looking to do is to just show a sample of what I'm trying to do. Whatever is in cell A2 (District 3), I want the formulas in column B to...

Hello, I am trying to figure out a formula that will allow one spreadsheet to pull in data from another. I have one spreadsheet that contains data relating to staff in columns A to BO and an Area Pay Code relating to each member of staff is in column S. I will call this spreadsheet Full...

I have this formula in N2 =IF(AND(A2="Y",H2>0),5,10) I can't figure out how to get N2 to be blank if A2 is blank. This is for a golf league where if they play at least once within a month, they pay $5. If they haven't played within the month, they will pay $10 if they want to participate (A2)...

I am trying to find how to return the workers pay the maximum number of weeks after their start date. As you can see in the example below, I have tried to OFFSET by the number of weeks (G2). However, this is returning the pay for worker Bob instead of the last instance of Paul (£25). I basically...

Hello all, I'm having a bit of a problem, and I'm hoping there's a simple solution. I am trying to enter in Cell B1 an annual pay amount ($28,600), then in C1 place the number of hours worked per week (50), then the next cell D1 should display the hourly pay rate ($10). Iv'e managed to...

I'm trying to calculate how many bi-weekly checks total in a given month, how many have past month and how many are remaining. For example I used the formula "=3-(A3-MOD(A3-P$3-1,14)+41 >EOMONTH(A3,0))" to calculate total # of bi-weekly checks in any given month, A3 being the date of month in...