IF or SUMIF help for Overtime Formula

M

Myrna

Hi,

This is a Semi-Monthly Payroll Sheet
B5 to H5 = 7 days
I5 to O5 = 7 days
S5 = 1 day
T5 is hourly rate $8
U5 = Gross Pay (Need the formula inserted here)

If my worker works 49 hours the first 7 days. He will be paid overtime
for this.
If my worker works 15 hours the 2nd 7 days. There is no overtime
And the final day 1 hour. There is no overtime.

Notice the total hours add up to 65 hours.
 
E

ehntd

What is the overtime rate? And is it somewhere in the sheet? Also
instead of having the total in U5, can you have a subtotal for week
and then a subtotal for week 2 and then add them? Since the two week
are separate then that has to be taken into consideration. Let me kno
and I´ll help you with this
 
M

Myrna

Ehntd,
The overtime rate is 1 1/2.
No it is not on the sheet.
No I do not a subtotal for each week!
Technically there are 3 weeks for the 15 cells spaces
B5:H5 = 7 days
I5:O5 = 7 days
P5 = 1 day
These are the cells for the semi-monthly time sheet
T5 = $8
U5 = Gross Pay ( I thought this is the place for the formula)

Yes, we could redesign the sheet if needed.
If it is easier to calculate the formula this way.
Thought it would be easier the calculate the 15 working day in one cell.
Myrna,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top