Calculate lunch time
Hi can anyone help me with timesheet?
I try to calculate lunch time but it doesn't work
For example Start at 10 o'clock end at 2 o'clock of which 30 minutes break. Then a total of 3:30 hours
Mac mini, macOS 10.15
Question marked as
Top-ranking reply
B2 and C2 both contain Date and Time values. Subtracting the (B2) earlier from the later (C2) returns a result that is a Duration.
I suspect the value in D2 is also a Date and Time value. You cannot subtract a Date and Time from a Duration—the result, as seen in your screen shot is an error.
Change the data format of column D to Duration and re-enter the values, or change your notation of the lunch 'time' to this less ambiguous style: 1h or 60m (D2), 30m (D3), 15m (D5), etc.
Regards,
Barry