Example Data
| # | Date | Start | End | Timezone | Elapsed (HH:MM:SS) | Total Minutes |
|---|---|---|---|---|---|---|
| 1 | 2025-08-01 | 08:15:00 | 10:00:00 | UTC | 01:45:00 | 105.00 |
| 2 | 2025-08-01 | 22:30:00 | 01:00:00 | UTC | 02:30:00 | 150.00 |
| 3 | 2025-08-02 | 09:00:30 | 09:45:15 | UTC | 00:44:45 | 44.75 |
Formula Used
Let S = resolved start datetime, E = resolved end datetime in the selected timezone.
If E < S, set E = E + 1 day.
Let Δ = E − S, where Δ gives days (d), hours (h), minutes (m), seconds (s).
TotalMinutes = d × 1440 + h × 60 + m + s ÷ 60
HH:MM:SS = (d × 24 + h) : m : s (zero‑padded).
This approach avoids errors around midnight and includes seconds as fractional minutes.