Minutes to decimal hours

Convert hours and minutes to decimal hours and back, with a full 0 to 59 minute chart.

7:45 = 7.75
465 minutes in total

Minutes to decimal chart

Minutes past the hour on the left, the decimal to put on payroll on the right. Rounded to two places, which is how nearly every payroll system stores it.

MinHours
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
160.27
170.28
180.30
190.32
MinHours
200.33
210.35
220.37
230.38
240.40
250.42
260.43
270.45
280.47
290.48
300.50
310.52
320.53
330.55
340.57
350.58
360.60
370.62
380.63
390.65
MinHours
400.67
410.68
420.70
430.72
440.73
450.75
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

Why payroll uses decimal hours

A time clock records hours and minutes, but payroll multiplies hours by a dollar rate, and you cannot multiply 7 hours 45 minutes by $18 directly. The minutes have to become a fraction of an hour first. Forty five minutes is three quarters of an hour, so 7:45 becomes 7.75, and 7.75 × $18 = $139.50. Every payroll system, spreadsheet and pay stub works in decimal hours for this reason.

The conversion is a single division: decimal = minutes ÷ 60. Add the result to the whole hours. The chart above lists every minute from 0 to 59 so you do not have to divide at all; find the minutes on the left and read the decimal on the right.

Worked examples

Time card showsMinutes ÷ 60Decimal hours
8:1515 ÷ 60 = 0.258.25
7:2020 ÷ 60 = 0.333…7.33
6:5050 ÷ 60 = 0.833…6.83
39:4040 ÷ 60 = 0.666…39.67
42:077 ÷ 60 = 0.116…42.12

The most common mistake: 7.30 is not 7:30

Writing 7 hours 30 minutes as 7.30 underpays by twenty minutes at a time, because 7.30 decimal hours is only 7 hours 18 minutes. The correct decimal is 7.50. The same error turns 8:45 into 8.45 instead of 8.75. Over a two week pay period with ten shifts, the gap can easily reach several hours. If a pay stub shows totals that look like clock time with a dot in place of the colon, check them against the chart.

Going the other way: decimal to hours and minutes

To turn decimal hours back into minutes, multiply the part after the point by 60. 7.75 hours is 7 hours plus 0.75 × 60 = 45 minutes. 38.4 hours is 38 hours plus 0.4 × 60 = 24 minutes. The second field in the converter does this for you as you type.

Tenths and hundredths

Some employers record time in tenths of an hour (six minute blocks) rather than exact minutes. In that system 0.1 = 6 minutes, 0.2 = 12 minutes and 0.5 = 30 minutes, and every punch is rounded to the nearest tenth. That practice is allowed under federal rules as long as it averages out fairly over time; see the time clock rounding rules guide. The chart here uses hundredths, which is what you want when no rounding is applied.

A common tenth-of-an-hour lookup; exact boundaries depend on the rounding method an employer uses.
Tenth of an hourMinutes covered
0.11 to 6
0.27 to 12
0.313 to 18
0.419 to 24
0.525 to 30
0.631 to 36
0.737 to 42
0.843 to 48
0.949 to 54
1.055 to 60

Totalling a whole week

Convert each day first or total the minutes first; the answer is the same as long as you carry minutes over 60 into the hours column. The simplest way is to skip the arithmetic and enter the punches in the time card calculator, which shows every day and the weekly total in both h:mm and decimal.

Frequently asked questions

What is 45 minutes in decimal?

0.75 hours. Divide 45 by 60.

What is 8 hours and 20 minutes in decimal?

8.33 hours. 20 ÷ 60 = 0.333, rounded to 0.33.

How do I convert minutes to decimal in Excel?

If the time is in cell A1 as an Excel time (7:45), use =A1*24 and format the cell as a number. If you have plain minutes in A1, use =A1/60.