Timesheet with overtime and double time

[ymqiao]

Hi there,

I have a problem to figure out the overtime and double time formula. Is anybody can help?
See the total hours 13:00, the overtime should be 4:00, and double time should be 1:00, I don't know how to do it. Help pls ASAP



Time In Lunch out Lunch in Time Out TOTAL HOURS Reg OT DT Activity Code *
8:00 AM 12:00 PM 1:00 PM 7:00 PM 10:00 8:00 2:00 0:00
8:00 AM 12:00 PM 1:00 PM 6:00 PM 9:00 8:00 1:00 0:00
8:00 AM 12:00 PM 1:00 PM 3:00 PM 6:00 6:00 0:00 0:00
8:00 AM 12:00 PM 1:00 PM 9:00 PM 12:00 8:00 4:00 0:00
8:00 AM 12:00 PM 1:00 PM 10:00 PM 13:00 8:00 5:00 0:00
8:00 AM 12:00 PM 1:00 PM 8:00 PM 11:00 8:00 3:00 0:00

[[email protected]]

Please attached sample excel sheet.

Regards,
Suhas

[Toonies]

try this in G3 and copy down

Please Login or Register  to view this content.

reference to your previous post

http://www.excelforum.com/excel-gene...uble-time.html