Record 3 work shifts (breakfast, lunch, dinner), each to include a start time and stop time.
calculate total hours worked
calculate total hours between shifts ( on break)
calculate money earned after input of hourly rate.
I’m having difficulty getting the correct results when the data is entered on a different day to which it relates. IE: the following day
it’s calculating the day as well as the time.
Is there a formula to force the calculation on the time only?
iPad, iPadOS 16
Yes, Numbers always includes Date and Time even if you display just the time Time.
You can have your formula "ignore" the date part by doing something like this:
=MOD(B3−A3,"12h")
where stop time is in B3 and start time in A3.
This also addresses the problem with the negative result you might have if a shift "crosses" midnight.
Use ; instead of , in the formula if your region uses , as the decimal separator.
Also, if the word for day in your language begins with a letter other than d then use that letter instead.
SG
Time Sheet
