Minutes to decimal hours for payroll

Payroll needs hours as decimals, so 7 hours 45 minutes becomes 7.75. Divide the minutes by 60, or look them up in the full 0 to 60 chart.

Published by ThatToolSite

Type a time like 7:45 or 37 h 50 min into the decimal hours calculator to get the decimal, or type a decimal to get hours and minutes back.

Convert hours and minutes

The formula

An hour has 60 minutes, so a minute is one sixtieth of an hour. To turn minutes into a decimal, divide them by 60 and keep the whole hours in front.

Decimal hours = hours + (minutes ÷ 60)

7 h 45 min = 7 + 45 ÷ 60 = 7 + 0.75 = 7.75 hours

Payroll systems, invoices and spreadsheets want this form because you can multiply it by an hourly rate. You can’t multiply 7:45 by $20 directly.

Minutes to decimal hours chart (0 to 60)

Every minute from 0 to 60, rounded to two decimal places, which is what most payroll systems use. Add the whole hours in front: 8 hours 20 minutes is 8.33.

MinutesHours
00.00
10.02
20.03
30.05
40.07
50.08
60.10
70.12
80.13
90.15
100.17
110.18
120.20
130.22
140.23
150.25
MinutesHours
160.27
170.28
180.30
190.32
200.33
210.35
220.37
230.38
240.40
250.42
260.43
270.45
280.47
290.48
300.50
MinutesHours
310.52
320.53
330.55
340.57
350.58
360.60
370.62
380.63
390.65
400.67
410.68
420.70
430.72
440.73
450.75
MinutesHours
460.77
470.78
480.80
490.82
500.83
510.85
520.87
530.88
540.90
550.92
560.93
570.95
580.97
590.98
601.00

Only multiples of 3 minutes come out exact, such as 3 = 0.05, 6 = 0.10 and the quarter hours (15 = 0.25, 30 = 0.50, 45 = 0.75). The other values repeat forever and are rounded, such as 20 minutes = 0.3333…, shown as 0.33. If your system keeps three decimals, 1 minute is 0.017 and 20 minutes is 0.333.

Converting decimal hours back to minutes

Multiply the part after the decimal point by 60.

6.6 hours: 0.6 × 60 = 36, so 6 h 36 min

7.83 hours: 0.83 × 60 = 49.8, so about 7 h 50 min

The second line shows why two-decimal values don’t always map back to a whole minute: 0.83 is itself a rounded value of 50 ÷ 60. Round the result to the nearest minute.

A payroll example, and why the rounding step matters

An employee works 37 hours 50 minutes in a week at $18.40 an hour.

MethodHours usedPay
Exact minutes: 2,270 min × $18.40 ÷ 6037.8333…$696.13
Rounded to 3 places37.833$696.13
Rounded to 2 places37.83$696.07

Rounding the hours to two places first costs this employee 6 cents. It looks trivial, but it happens every week and always in the same direction for that minute value. The safest order is to keep the total in minutes, multiply, then round the money once. The time card calculator keeps exact minutes for the whole week and only rounds what it displays.

Rounding punches to 5, 6 or 15 minutes

Converting minutes to decimals is different from rounding clock punches. Many employers round start and stop times, and US federal rules (29 CFR 785.48) accept rounding to the nearest 5 minutes, tenth of an hour or quarter of an hour, as long as it averages out over time and employees are paid for all the time they actually work.

  • Tenths of an hour are 6-minute blocks: 6 min = 0.1, 12 = 0.2, 18 = 0.3, up to 54 = 0.9.
  • Nearest quarter hour: 1 to 7 minutes past a quarter rounds down and 8 to 14 rounds up, because the halfway point is 7.5 minutes.

A rounding policy that only ever rounds in the employer’s favour doesn’t average out. State rules can be stricter, so treat this as background, not legal advice.

Common mistakes

  • Writing 7:30 as 7.30. It’s 7.50. A decimal point after the hours never holds minutes.
  • Adding times as if they were decimals. 7:45 + 8:30 is 16:15 (16.25 hours), not 15.75. Convert each to decimals first, or add hours and minutes separately.
  • Rounding each day, then the week. Rounding twice adds error. Add the minutes, then convert once.
  • Spreadsheet times. Spreadsheets store 7:45 as a fraction of a day (0.3229…). Multiply by 24 and format the cell as a number to see 7.75.

Sources