Forum Discussion
Overtime Calculation Values
I have a time sheet that uses rows for job names and each column is a day of the week running Wednesday thru Tuesday. At the bottom of the sheet (C40:I40) is straight time (no overtime). Straight is ...
That's since Time & Half formula returns negative values for some days, and applied to these cells numbers doesn't show negative numbers and zeroes. You may change applied format, or formula like
=MAX(0,MIN(SUM(C9:C39)-8,4))or both.
Didn't catch what it shall be in next row.
@SERGEI Hope you are well, can you tell me what formula to use if the value is more than 8 hours for a day off but I can only deduct 8 hours for day off (normal working hours are only 8 hours) thnx