Horas

Minutes to decimal chart: 1 to 60 minutes in hours

Quick answer

This minutes to decimal chart turns each minute into decimal hours, the format payroll uses: divide the minutes by 60. 15 minutes is 0.25 hours, 30 is 0.50, 45 is 0.75 and 20 is 0.33. The table lists every minute from 1 to 60, rounded to two and three places, for filling in a time card.

Updated 2 min readGambit Studio

The formula

Decimal hours = hours + minutes ÷ 60. 7 hours 48 minutes = 7 + 48 ÷ 60 = 7.80 hours. To go back, multiply the decimal part by 60: 7.80 hours → 0.80 × 60 = 48 minutes. If your employer rounds, use the two-place column; if you need precision for totals, keep three places and round once at the end.

Minutes to decimal hours, 1 to 60

MinutesDecimal (2 places)Decimal (3 places)
10.020.017
20.030.033
30.050.050
40.070.067
50.080.083
60.100.100
70.120.117
80.130.133
90.150.150
100.170.167
110.180.183
120.200.200
130.220.217
140.230.233
150.250.250
160.270.267
170.280.283
180.300.300
190.320.317
200.330.333
210.350.350
220.370.367
230.380.383
240.400.400
250.420.417
260.430.433
270.450.450
280.470.467
290.480.483
300.500.500
310.520.517
320.530.533
330.550.550
340.570.567
350.580.583
360.600.600
370.620.617
380.630.633
390.650.650
400.670.667
410.680.683
420.700.700
430.720.717
440.730.733
450.750.750
460.770.767
470.780.783
480.800.800
490.820.817
500.830.833
510.850.850
520.870.867
530.880.883
540.900.900
550.920.917
560.930.933
570.950.950
580.970.967
590.980.983
601.001.000

Common time card examples

Time workedDecimal hoursAt $20/hour
7 h 20 min7.33$146.67
7 h 45 min7.75$155.00
8 h 10 min8.17$163.33
8 h 25 min8.42$168.33
8 h 50 min8.83$176.67
38 h 10 min38.17$763.33

Pay amounts use the unrounded hours (7 h 20 min × $20 = 7.333… × 20). Rounding the hours to two places first can move the total by a few cents.

In Excel or Google Sheets

  • Minutes in A2: =A2/60
  • A time value such as 7:48 in B2: =B2*24 (format the result as Number), because Excel stores time as a fraction of a day (Microsoft).
  • Hours and minutes in separate cells: =C2+D2/60
  • Decimal back to time: =E2/24, formatted as [h]:mm.

To get the hours themselves from clock-in and clock-out times, see how to calculate hours worked, with a calculator.

The app we're building

What the app will do that this page can't: We're building Hours Calculator, an iPhone app that will keep every day on your iPhone, total the week and the month on its own, show overtime with the estimated pay from your hourly rate and export a PDF time card, with no account and no internet. It is not on the App Store yet: leave your email and we will tell you when it launches.

Sources

  1. Microsoft Support: Add or subtract time in Excel

Frequently asked questions

What people ask most about this, answered with the source.

What is 45 minutes as a decimal?
45 minutes is 0.75 hours (45 ÷ 60).
What is 20 minutes as a decimal?
20 minutes is 0.33 hours rounded to two places (20 ÷ 60 = 0.333…).
How do you convert minutes to decimal in Excel?
Divide the minutes by 60 (=A2/60). If the cell holds a time such as 7:48, multiply by 24 (=B2*24) and format the result as a number.
How do I convert decimal hours back to minutes?
Multiply the decimal part by 60: 6.40 hours = 6 hours + 0.40 × 60 = 6 hours 24 minutes.
What is 7 hours and 20 minutes in decimal?
7 hours 20 minutes is 7.33 hours (7 + 20 ÷ 60).
HorasComing soon to the App Store
Notify me at launch