A B C D E F
G H
Day Start End -meal Reg Hrs O/T Hrs Total
8:00

40:00
Mon 11:59 23:59 00:30 8:00 3:30 11:30
Tue 11:59 23:59 00:30 8:00 3:30 11:30
Wed 11:59 23:59 00:30 8:00 3:30 11:30
Thu 11:59 23:59 00:30 8:00 3:30 11:30
Fri
Sat 11:59 23:59 00:30 8:00 3:30 11:30
Sun 11:59 23:59 8:00 4:00 11:30
Total 48:00 21:30
69:30

I need to calculate overtime as follows: Over 8 hrs daily
Over 40 hrs
Weekly

I was able to calculate the daily reg and O/T =MIN($h$2,g4) and
=max(0,g4-$h$2). How do I calculate the over 40 hrs per week?


Thanks
Bunny


--
bunnyc
------------------------------------------------------------------------
bunnyc's Profile: http://www.excelforum.com/member.php...o&userid=31662
View this thread: http://www.excelforum.com/showthread...hreadid=514590