Calculate hours for a shift across midnight
Fill D2:D5 with numeric hours for shifts shorter than 24 hours. A and B are numeric clock times at minute precision, C is integer unpaid break minutes. The end may be on the next day; equal endpoints mean zero duration. Return Review for negative breaks or breaks longer than the shift. No timezone, daylight-saving, overtime or payroll policy is inferred.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Fill D2:D5 with numeric hours for shifts shorter than 24 hours. A and B are numeric clock times at minute precision, C is integer unpaid break minutes. The end may be on the next day; equal endpoints mean zero duration. Return Review for negative breaks or breaks longer than the shift. No timezone, daylight-saving, overtime or payroll policy is inferred.
No account. No upload. Just try it.