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
Bookmarks