Calculate hours for a shift across midnight
Your goal: Use one-day clock wrap, whole-minute arithmetic and a declared break rule to calculate numeric paid hours.
Full 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.
Day, overnight, equal clocks and an excessive breakPlace shift row 2 across midnight
Clock displays represent stored numeric day fractions. Elapsed duration and wrapped clock readings differ.
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 |
Step 1 of 4
Place shift row 2 across midnight
Rules for this step
Use an under-24-hour span. Equal clocks mean zero minutes. A negative break or a break longer than the span needs Review.