How to Use
- Enter start date & time (e.g., 2026-05-20 09:00).
- Enter end date & time (e.g., 2026-05-20 17:30).
- Click Calculate — get hours, minutes, and decimal hours.
- For overnight (22:00 → 06:00), include the next day’s date — duration = 8h.
Example 1 — Day shift
09:00 → 17:00 = 8h 0m (8.0h)
Minus 30m lunch → 7.5h payable
Example 2 — Night shift
22:00 (Day 1) → 06:00 (Day 2) = 8h 0m
Cross-midnight handled via date, not just time
| Scenario | Input | Duration |
|---|---|---|
| Standard 9-5 | 09:00 → 17:00 | 8h |
| With break | 09:00 → 17:30 minus 30m | 8h |
| Overtime | 09:00 → 19:00 | 10h (2h OT) |
| Multi-day | May 1 14:00 → May 3 10:00 | 44h |
Formula
Timestamps in seconds; handles DST if dates included