Hours to Decimal & Timesheet Rounding Calculator

Enter up to 31 shifts to convert exact worked minutes to decimal hours. Compare three places to apply the same nearest-minute grid and see the difference each approach makes to credited minutes. An optional straight-time rate estimates the dollar change. The ledger traces recorded and rounded clock punches, unpaid time and net minutes for each shift.

Time records

Decimal hours and timesheet rounding

Timesheet settings

Clock punches and unpaid time

An earlier clock-out time is treated as the following day. Enter the unpaid minutes for each shift.

Shift 1
Shift 2
Shift 3
Shift 4

Exact net time 31.7667 decimal hours.

Decimal hours and rounding comparison

Exact decimal hours
31.7667 h
31 h 46 min · 1906 net minutes
Credited time versus exact minutes
Round each punch
31.6667 h · -6 min · -$2.50 straight-time change
Round each shift
32.0000 h · +14 min · $5.83 straight-time change
Round the combined total
31.7500 h · -1 min · -$0.42 straight-time change

The pay comparison uses a single straight-time rate. It excludes overtime premiums and deductions.

Shift-by-shift rounding ledger

ShiftRecorded punchesUnpaidExact netDecimal hoursRounded punchesPer-punch netRounded shift
Mon08:04 to 16:2830 min474 min7.900008:00 to 16:30480 min480 min
Tue08:08 to 16:5130 min493 min8.216708:15 to 16:45480 min495 min
Wed night22:56 to 07:02 next day20 min466 min7.766723:00 to 07:00 next day460 min465 min
Fri09:00 to 17:2330 min473 min7.883309:00 to 17:30480 min480 min

Show selectable CSV

How to use this calculator

  1. Enter a clock-in, clock-out and unpaid minutes for each shift. Use zero for a shift with no unpaid break.
  2. Select the nearest-minute increment. One minute preserves minute-resolution entries.
  3. Add a straight-time hourly rate if you want a dollar comparison, or leave it blank to compare time alone.
  4. Read exact decimal hours and the three rounding results. Check the shift ledger to trace any change to the rounded punches or duration.
  5. Download the timesheet CSV to keep each comparison and its underlying shifts together.

The Formula

The mathematical logic powering this calculation is:

Convert each 24-hour punch to minutes after midnight. Add 1,440 minutes to the end when it precedes the start. Exact net = end − start − unpaid minutes. Decimal hours = net minutes ÷ 60. Equal punches represent zero elapsed minutes. Each row represents one shift shorter than 24 hours. Enter separate nonoverlapping shifts and the unpaid minutes for each.

For increment k, nearest grid point = k × floor(value ÷ k + 1/2). Ties move toward later clock time or higher duration. The per-punch method rounds both punches relative to the same midnight and then subtracts the exact unpaid minutes. The per-shift method rounds each exact net duration before summing. The combined method sums exact net minutes first and rounds the sum once. A per-punch total is unavailable when unpaid minutes exceed a shift's rounded span.

Credited change is rounded minutes minus exact minutes. Optional straight-time pay change = credited change × hourly rate ÷ 60, rounded to cents with ties away from zero. The export lists exact minutes plus decimal-hour displays rounded to four places. A decimal fraction of an hour is measured in sixtieths of an hour, so 7.50 h is 7 hours 30 minutes.

The workbook takes 1–31 rows, whole minutes, and 1, 5, 6 or 15 minute increments. All local days are treated as 24 hours. Enter any overnight work that crosses a daylight-saving transition as equivalent elapsed time using adjusted punches. Overtime, deductions and pay-rule eligibility are outside the calculation. The Department of Labor describes common rounding practices and the conditions for their use. Review actual recorded and credited time when auditing pay over a period.

Worked Example

If you input:

  • Mon: 08:04 to 16:28 with 30 unpaid minutes
  • Tue: 08:08 to 16:51 with 30 unpaid minutes
  • Wed night: 22:56 to 07:02 the next day with 20 unpaid minutes
  • Fri: 09:00 to 17:23 with 30 unpaid minutes
  • Settings: 15 minute increment and $25 per hour

Result:

Exact time is 1,906 minutes, or 31.7667 hours. Per-punch rounding gives 1,900 minutes and reduces straight-time pay by $2.50. Rounding each net shift gives 1,920 minutes, while rounding the exact combined total gives 1,905 minutes.

Frequently Asked Questions

How do I convert 7 hours 45 minutes to decimal hours?

Divide 45 by 60 and add the result to 7. The total is 7.75 hours.

Why can punch rounding and shift rounding give different totals?

Punch rounding moves each end of a time span independently. Shift rounding first finds the exact span less unpaid time, then moves that single net duration to the chosen grid.

How are overnight shifts counted?

When clock-out is earlier than clock-in, the calculator places clock-out on the following day. For example, 22:00 to 06:00 covers eight elapsed hours before breaks.

Why is my per-punch result unavailable?

Check the shift ledger for a rounded span shorter than its recorded unpaid minutes. The exact, per-shift and combined results still use the recorded elapsed time and breaks.

Which amount should I compare with a pay stub?

Use the minutes and decimal-hour total for the rounding approach your records identify. This straight-time estimate holds the hourly rate fixed and separately reports how the choice of rounding changes the model.

Similar Calculators