Please clarify

1. Calculate daily hours worked.
2. Pay overtime in excess of 8 hours daily
3. Pay double overtime to anything in excess of 40 min if the person
worked for the 7 days, and single OT to anything less than 40 minutes
in excess of 8 hours.

Is that what you need ?

Regards

Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=376867