Enter Shift Details
Results
Actual duration (hh:mm)
—
After break deduction
Rounded duration (hh:mm)
—
Policy applied
Rounded hours (decimal)
—
Useful for payroll
Show step-by-step calculation
Logged Entries
Build a batch and export to CSV or PDF.
| # | Start | End | Overnight | Break | Base | Mode | Ties | Per-punch | Actual | Rounded | Decimal |
|---|
Example Data
Click “Load” to send a row into the form.
| Start | End | Overnight | Break | Base | Mode | Ties | Per‑punch | |
|---|---|---|---|---|---|---|---|---|
| 09:02 | 17:06 | No | 30 | 15 | Nearest | up | Total | |
| 07:58 | 16:03 | No | 45 | 15 | Nearest | even | Per-punch | |
| 22:57 | 06:12 | Yes | 20 | 15 | Up | up | Per-punch | |
| 08:11 | 12:49 | No | 0 | 6 | Nearest | down | Total |
Formula Used
Let B be the rounding base in minutes (default 15). For any value x in minutes, define remainder r = x mod B.
- Always down: result = x − r.
- Always up: result = x + (B − r) if r > 0, else x.
- Nearest:
- If r < B/2 − G, round down (G = grace minutes).
- If r > B/2 + G, round up.
- If |r − B/2| ≤ G, apply ties rule: up / down / even.
For per‑punch, round start and end separately before subtraction. For total‑only, compute net minutes then apply rounding once.
How to Use This Calculator
- Enter start and end times. Toggle “overnight” if end is next day.
- Set unpaid break minutes, rounding base, mode, grace, and ties.
- Choose per‑punch or total‑only policy.
- Click Calculate to view step‑by‑step and results.
- Use Add to log to build a batch, then export CSV or PDF.
FAQs
It is a policy that rounds time to 15‑minute increments. With the classic 7‑minute rule, minutes 1–7 round down and 8–14 round up.
Most policies use “Nearest” with a specified grace window and a tie rule. “Up” or “Down” are used in specific compliance or scheduling contexts.
Per‑punch rounds clock‑in and clock‑out individually before subtraction. Total‑only computes net minutes first, then rounds once at the end.
Grace defines a window around the midpoint. Minutes inside that window follow the chosen ties rule; outside it, values round up or down normally.
Yes. Although this tool defaults to 15 minutes, you can choose 5, 6, 10, or 12 to match alternate policies.
Notes
This tool is for general guidance. Check applicable labor rules and company policy before adopting a rounding scheme.
Rounding Windows Within Any Hour (Quarter-Hour, Grace = 0)
These windows implement the classic “7-minute rule” for nearest rounding to 15 minutes.
| Minute range in hour | Rounds to | Example |
|---|---|---|
| :53 – :07 | hh:00 | 12:56 → 13:00 |
| :08 – :22 | hh:15 | 09:12 → 09:15 |
| :23 – :37 | hh:30 | 10:29 → 10:30 |
| :38 – :52 | hh:45 | 14:44 → 14:45 |
Quarter-Hour to Decimal Hours Lookup
Use this when converting rounded time to payroll decimal hours.
| Minutes | Decimal hours | HH:MM |
|---|---|---|
| 0 | 0.00 | 00:00 |
| 15 | 0.25 | 00:15 |
| 30 | 0.50 | 00:30 |
| 45 | 0.75 | 00:45 |
| 60 | 1.00 | 01:00 |
| 75 | 1.25 | 01:15 |
| 90 | 1.50 | 01:30 |
| 105 | 1.75 | 01:45 |
| 120 | 2.00 | 02:00 |
| 135 | 2.25 | 02:15 |
| 150 | 2.50 | 02:30 |
| 165 | 2.75 | 02:45 |
| 180 | 3.00 | 03:00 |
Per‑Punch vs Total‑Only: Worked Example (Nearest • Base 15 • Break 30)
This example shows how policies can yield different totals.
| Start | End | Overnight | Raw (hh:mm) | Per‑Punch (hh:mm) | Total‑Only (hh:mm) | Notes |
|---|---|---|---|---|---|---|
| 08:01 | 16:08 | No | 07:37 | 07:45 | 07:30 | Per‑Punch rounds 08:01→08:00 and 16:08→16:15, then subtracts break. |
Tip: Toggle “per‑punch” to match timeclock rounding versus spreadsheet-only rounding.