Blog

Minutes to decimal hours for payroll: a chart and the traps

· payroll, time & attendance

To convert minutes to decimal hours for payroll, divide the minutes by 60. Seven minutes is 7 ÷ 60 = 0.1167 hours, which most payroll screens show as 0.12. Thirty minutes is 0.50, fifteen is 0.25, and forty-five is 0.75. The division is easy. What causes trouble is the rounding that follows it, and the habit of converting each day separately instead of converting once at the end.

Minutes to decimal hours: common values

Payroll systems and spreadsheets want hours as a number, so 8 hours 7 minutes becomes 8.12 rather than “8:07”. The whole-hour part stays put and only the minutes get converted. The table below covers the common values of the minutes part, to four decimal places and then to the two places most pay screens use.

MinutesExact (minutes ÷ 60)Two decimals
10.01670.02
20.03330.03
30.05000.05
40.06670.07
50.08330.08
60.10000.10
70.11670.12
80.13330.13
90.15000.15
100.16670.17
120.20000.20
150.25000.25
200.33330.33
300.50000.50
400.66670.67
450.75000.75
500.83330.83
550.91670.92
590.98330.98

Only a few of these are clean: multiples of 3 minutes land on a tidy hundredth (3 is 0.05, 6 is 0.10, 9 is 0.15, 12 is 0.20), and everything else repeats forever. That is the root of every rounding problem below. A shift of 8 hours 7 minutes is 8.12 on the screen and 8.1167 in truth.

The method, step by step

  1. Convert the whole shift to minutes first: hours × 60 plus minutes. A shift of 7 hours 52 minutes is 472 minutes.
  2. Subtract any unpaid break in minutes, not in decimals. Thirty unpaid minutes off 472 leaves 442.
  3. Add up the whole week in minutes.
  4. Divide by 60 once, at the end, and round only that final number.

Step 4 is the one people skip, and it is where money moves.

How rounding moves pay: a worked example

An invented front desk agent at a 38-room motel off a highway exit works five shifts a week of 7 hours 52 minutes each, with a placeholder wage of $16 an hour. The true total is 5 × 472 = 2,360 minutes, which is 39.3333 hours, or $629.33.

Here is what three common ways of converting do to that week.

MethodPer shiftWeekly hoursWeekly payDifference from true
Exact minutes, one division at the end472 min39.3333$629.33none
Each day to two decimals7.8739.35$629.60+$0.27
Each day to one decimal7.939.50$632.00+$2.67
Each day truncated, not rounded7.8639.30$628.80−$0.53

Truncating means chopping the extra digits off instead of rounding them, which is what some older spreadsheets do by default. It can only ever under-pay, because it never rounds up. Rounding to one decimal over-pays here, but it would under-pay on a different shift length. The direction depends on the minutes, which is why a rule you cannot see is hard to trust.

The ten-minute over-payment in the one-decimal row looks small. Run it for 52 weeks on one person and it is 520 minutes, 8.67 hours, or $138.67 a year. Multiply by a roster and it stops being a rounding error. The same logic works against the employee when the error runs the other way, and an employee who is short 2 minutes every day will notice faster than an owner who is over by 2.

Where it bites near overtime

Hours converted to a decimal also get compared to a threshold. Federal law sets overtime at 1.5 times the regular rate after 40 hours in a workweek, and some states add daily thresholds on top, so check your own state. Per-day rounding can push a week across that line that was never over it.

Take a week of four shifts at 7 hours 58 minutes (478 minutes) and one at 8 hours 8 minutes (488 minutes). The true total is 2,400 minutes, exactly 40.00 hours, so nothing is over. Convert each day to two decimals and you get 7.97 four times and 8.13 once: 31.88 + 8.13 = 40.01. A system that sums the rounded days now sees one hundredth of an hour of overtime, and a payroll file will carry it. The dollars are trivial and the principle is not: overtime hours belong to exact minutes, never to a rounded figure. To see what a day’s hours above a daily threshold are worth, the overtime calculator compares a day against a threshold; keep your own totals in minutes and convert once at the end.

What a time clock should store

The rule for any system you buy or build: store the punch as a timestamp, derive minutes from the timestamps, and do all rounding at the last step, at display or at payroll export. A clock that stores 8.12 has already thrown away 0.0033 hours (12 seconds) per shift and cannot get it back.

Two related questions are separate from decimal conversion, and worth keeping apart:

  • Rounding punches to a quarter hour is a policy decision with its own rules. See the 7-minute rule and where a hotel time clock breaks before adopting it.
  • Whether your payroll provider wants decimal hours or hours-and-minutes is set by the provider. Ask which, and whether it rounds again on its side. Two roundings of the same number can add up to a third result.

If your records already live as exact punch times, you can start a free trial and compare a week of exact minutes against what your current payroll shows. If they do not, the table above will keep you honest by hand.

When this breaks

  • Paying in minutes. Some payroll tools accept hours and minutes, and then there is nothing to convert. Use that if it exists.
  • A fixed salary. Salaried staff are not paid by the hour, so decimals only matter for tracking.
  • Seconds. Clocks that record seconds make the table above coarse. The method is the same: sum first, divide once.
  • Your payroll provider’s rounding. Convert your own week first, then compare it with what the provider shows. A mismatch of a few hundredths almost always points to per-day rounding on one side.

None of this replaces your payroll provider’s documentation or your state’s rules on how time must be recorded. The aim is narrower: keep the exact minutes, round once, and know which direction your rounding leans.

Start seeing what labor actually costs

Set up your property, put staff on the clock, and read tomorrow morning’s labor number.

14-day free trial · No credit card · Cancel anytime