Calculate Overtime

[Prince_Kendrick]

Okay, I am trying to figure out some overtime and things of that nature thru a spreadsheet. Trying to make the spreadsheet come up with everything. but I have an employee that works 100 hours. After 40 is overtime where they get time and a half. After 50 hours, they get double time. How could I break these all up and get a spreadsheet to calculate that with a $8.75 hourly pay rate. Help is desperately needed. THanks!

[davesexcel]

Nobody knows what your worksheet looks like, supplying a sample workbook would help...
Also, please read the forum rules, especially about thread titles.

[clownfish]

if hourly rate is in A2 and total hours is in B2, total pay is given by:

Please Login or Register  to view this content.

format as dollar amount using Format-->Cells...-->Accounting

[Prince_Kendrick]

Here is the sample of my worksheet. Thanks.

[DonkeyOte]

I'm not quite sure what you're trying to achieve as your file has the info you need - you just need to make the references to 8.75 in H2 refer instead to cell $B2 ... if you alter B2 the other calcs should follow suit.
(Also you need to create formulae to calculate hours -- ie C2 = MIN(40,$I2)*ISNUMBER($I2); E2 = MAX(0,($I2-50)-40) & G2 = MAX(0,$I2-50)

There is another approach...

If for ex. you had the following headers:

A1: Employee
B1: Rate
C1: Hours
D1: Total
E1: 0
F1: 40
G1: 50

Then using your example:

A2: Kendrick Shavkey
B2: 8.75
C2: 100

formulae for:

total
D2: =SUMPRODUCT(--($C2>($E$1:$G$1)),$C2-($E$1:$G$1),$E2:$G2)

rates
E2: =$B2
F2: =($B2*1.5)-$E2
G2: =($B2*2)-SUM($E2:$F2)

Should give you the same result.