Calculating overtime

  • Thread starter Thread starter bunnyc
  • Start date Start date
B

bunnyc

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
 
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
 
Back
Top