Inputs
Export
Exports the example table and the most recent result.
Example data
| Scenario | Start | End | Duration | Blocks floor | Blocks ceil | Blocks round |
|---|---|---|---|---|---|---|
| Workday | 09:00 | 17:30 | 8h 30m | 17 | 17 | 17 |
| Evening class | 18:15 | 20:45 | 2h 30m | 5 | 5 | 5 |
| Overnight shift | 22:00 | 06:30 | 8h 30m | 17 | 17 | 17 |
| Billing block | 10:00 | 11:10 | 1h 10m | 2 | 3 | 2 |
Formula used
- Duration (minutes) =
end - start. If end is earlier than start, add 1440 minutes to end. - End time =
start + duration. - Offset:
end = start + steps × 30minutes. - Blocks (floor) =
⌊duration / 30⌋; Blocks (ceil) =⌈duration / 30⌉; Blocks (nearest) =round(duration / 30). - All times are in 24‑hour
HH:MMformat.
How to use
- Choose a calculation mode.
- Enter times in
HH:MM24‑hour format. - For durations, set hours and minutes. For offsets, set steps of thirty minutes.
- Pick the rounding view for block counts.
- Click Calculate to see results and a 30‑minute timeline.
- Export your table via CSV or PDF if needed.
FAQs
1) What happens if end time is earlier than start?
It assumes the end is on the next day and adds 24 hours to compute duration.
2) Which rounding should I use for billing?
Floor counts completed blocks, ceil charges any partial block as full, and nearest rounds to the closest 30 minutes.
3) Does it support seconds or AM/PM?
Input is HH:MM in 24‑hour time. Seconds and AM/PM are not used to keep the tool simple and consistent.
4) Can I subtract 30‑minute steps?
Yes. In offset mode, set steps to a negative number to subtract.
5) Why are my exports empty?
Ensure the example table is visible. The CSV and PDF export the example table and the last result.