Payroll tool

Payroll Time Clock Conversion

Turn a shift's hours and minutes into the decimal hours payroll pays on, with or without the rounding rule your time clock applies.

  • ScalesHundredths, tenths, quarters
  • Rounding ruleSelectable
  • Source29 CFR 785.48

Payroll hours

8.50

507 minutes → nearest 15 min = 510 minutes → 510 ÷ 60 = 8.5000 hours

0612182430364248546027 min past the hour → nearest 15 min = 30 min

Payroll conversion chart with rounding columns

01530456027 min → exact 0.45 · tenth 0.5 (30 min) · quarter 0.50 (30 min)

Teal circle: nearest tenth. Orange circle: nearest quarter. The slider highlights the chart row.

The hundredths column is the exact two-decimal value a time card or timesheet total carries. The other two columns show what the same minutes become under the two rounding rules most time clocks offer. Notice that every value ending in a 7 or 8 is where quarter-hour rounding changes direction.

MinutesHundredthsTenth hourQuarter hour
10.020.00.00
20.030.00.00
30.050.10.00
40.070.10.00
50.080.10.00
60.100.10.00
70.120.10.00
80.130.10.25
90.150.20.25
100.170.20.25
110.180.20.25
120.200.20.25
130.220.20.25
140.230.20.25
150.250.30.25
160.270.30.25
170.280.30.25
180.300.30.25
190.320.30.25
200.330.30.25
210.350.40.25
220.370.40.25
230.380.40.50
240.400.40.50
250.420.40.50
260.430.40.50
270.450.50.50
280.470.50.50
290.480.50.50
300.500.50.50
MinutesHundredthsTenth hourQuarter hour
310.520.50.50
320.530.50.50
330.550.60.50
340.570.60.50
350.580.60.50
360.600.60.50
370.620.60.50
380.630.60.75
390.650.70.75
400.670.70.75
410.680.70.75
420.700.70.75
430.720.70.75
440.730.70.75
450.750.80.75
460.770.80.75
470.780.80.75
480.800.80.75
490.820.80.75
500.830.80.75
510.850.90.75
520.870.90.75
530.880.91.00
540.900.91.00
550.920.91.00
560.930.91.00
570.951.01.00
580.971.01.00
590.981.01.00
601.001.01.00

How a time clock turns punches into decimal hours

.10.20.30.40.45.50.60.70.80.90.100

27 min → 0.45: cell 45 of 100, each cell 36 seconds. Grey cells are hundredths no whole minute ever produces.

An electronic time clock keeps the clock-in and clock-out as minutes, subtracts them, removes unpaid breaks and then stores the shift as hours and hundredths, because a pay rate multiplies against a decimal. A paper time card goes through the same step by hand: 8 hours 27 minutes becomes 8.45. ADP's published Minutes to Hundredths Chart for hourly employees uses exactly these values, 1 minute = 0.02 up to 60 minutes = 1.00, so a chart from one payroll provider reads the same as any other. QuickBooks Desktop Payroll goes a step further with a preference that sets how a typed entry is read: in decimal format 4:30 is interpreted as 4.5 hours, and in minutes format 4.5 is interpreted as 4 hours 30 minutes, so check which one is switched on before typing either.

Whether a company says timesheet conversion, time card conversion or time clock conversion, this minutes-to-hundredths step is the thing being described. The plain lookup without rounding columns is on the minutes to decimal chart.

Quarter-hour, tenth-hour and 5-minute rounding

15 minbreak 22.530 min27 min is 12 min into the 15–30 block; break point 7½ min → rounds up to 30

One block of the rule chosen above, enlarged. The dashed line is the break point; the circle is where the minutes land.

The U.S. wage-and-hour regulation on time clocks, 29 CFR 785.48(b), describes “the practice for many years of recording the employees' starting time and stopping time to the nearest 5 minutes, or to the nearest one-tenth or quarter of an hour” and accepts it for enforcement purposes provided that, over a period of time, it does not fail to compensate employees for all the time they have actually worked. Rounding, in other words, has to cut both ways.

Under quarter-hour rounding the break point is 7½ minutes into each block, so 7 minutes past the quarter rounds down and 8 minutes rounds up: 8:07 is treated as 8:00 and 8:08 as 8:15. Tenth-hour rounding works in 6-minute blocks with the break at 3 minutes, and 5-minute rounding at 2½ minutes. The calculator above applies the rule to the shift total; a clock that rounds each punch separately can land a hundredth away from that.

What the rounding rule does to the pay

Exact8.45 h → $169.00Nearest 158.50 h → $170.00Nearest 15 min moves the shift by +3 min → +$1.00 at $20.00/h

Top bar: the shift's exact hundredths at the rate. Bottom bar: the same shift after the rule chosen above. Move the rate to see the difference in dollars.

Payroll multiplies the stored hours by the hourly rate, so a rounding rule changes pay by exactly the minutes it adds to or removes from the shift. The comparison above uses the hours and rule entered in the calculator.