I am trying to do a spreadsheet with the daily hours of each employee for the week and then at the end have these divided into Normal Hours, Time & 1/2 and Double Time automatically. So when we manually enter in the total hours worked for each day it will calculate overtime automatically for the whole week.
Normal Hours are 7.6 per day, Time 1/2 is 2 hours and Double time is all hours after that per day.
My format is simple as per below but I cannot work out how to do a formula that will take the overtime hours from each day for the whole week and have the answer calculate into 1 cell for Normal, Time 1/2 & Double Time.
Wed Thur Fri Sat Sun Mon Tues Total Normal Hours Time 1/2 Double Time
10 10 10 6 8
Any help would be much appreciated.
Thanks
Bookmarks