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
Is that for single cell of for aggregation or what? Perhaps you could provide very small sample Excel file with manually added desired result. In general you may use MIN(8, value) to deduct.
- I tried =Min(8,(b15-a1) which returns 15 instead of 8
In this case
=MIN(8/24,B1-A1)Time in Excel is decimal part of the number, e.g. 01:00:00 = 1/24. please check in attached.