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 ...
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.
- Thank you Sergei. 🙂