Hi Myrna!

It depends on how you pay overtime and what you mean
by "then figure the single day also".

Do you pay OT only after an employee has worked 40 hrs?
Or, do you pay OT after an employee has worked 8 hrs a day?
What if an employee works 12 hrs on Monday and then calls
off on Tuesday?

You say that P5 is a single day. I have no idea what that
means.

Your basic setup should include a cell to calculate
regular hours and then another cell should calculate OT
hours.

Biff

-----Original Message-----
I have 5 employees.
How would you write this formula to calculate time and
1/2 over 40 hrs. in a
single week if even over 40hrs for the week and then
calcuate the same for
the second week then figure the single day also.

B5 to H5 is 1 week, I5 to O5 is 2nd week, P5 is a single
day. S5 = total
hours. T5 is Gross Pay = total hours x 8 an hr.
Myrna
--
Thank you
.