Weekly Timesheet

New Contributor

Hi there.  I'm trying to build a weekly spreadsheet for employee time. See attached file.  I'm having trouble with the formula to calculate an overtime total for each day, based on a maximum 10 hours of regular time a week and a maximum regular time of 40 hours per week.  Does anyone have any suggestions?



2 Replies

Hi @Jamie_Wurm 


For daily overtime use below formula in cell E6, drag it down and copy in rest of the Days columns 


For week use this formula in cell U6 and drag it down







As variant