I have a sheet that already has the total hours worked out (A1=date; B1=Day; C1=Start time; D1=End Time; E1=Total Hours; F1=Lunch 1/2 hour; G1=Total hours worked in that day). I now need a IF formula that can work out, per day, any hours above the regular 8 hours and any hours below the regular 8 hours and then at the end of the column SUM all the row values to give a total of what the actual overtime would be.
Bookmarks