Overtime is paid after 45 hours. I have managed to get my spreadsheet to calculate time with breaks included. However when I try to subtract (45) from the Total Hours worked I get an error. Dates and times that are negative or two large show as ######.
Date Day In Out In Out Total Hours Overtime Hrs. 10/2/2019 Wednesday 6:00:00 AM 12:15:00 PM 1:00:00 PM 5:00:00 PM 10:15 10/3/2019 Thursday 6:00:00 AM 5:00:00 PM 11:00 10/4/2019 Friday 6:00:00 AM 5:00:00 PM 11:00 10/5/2019 Saturday 10/6/2019 Sunday 10/7/2019 Monday 6:00:00 AM 5:00:00 PM 11:00 10/8/2019 Tuesday 6:00:00 AM 5:00:00 PM 11:00Total Hours Worked
=SUM(D12-C12)+(F12-E12) to calculate the hours
=SUM(G19-45) for the overtime
54:15:00 ###########