Calculating overtime
 

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

Calculating overtime
 

Can't quite work out your cell refs but if your daily OT is

=max(0,dailytotal-8)

then your weekly OT is

=max(0,weeklytotal-40)

or just sum your daily OTs


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