Minutes to Decimal Calculator (Hours to Decimal)
Convert minutes and hours to decimal hours and back as you type. Paste a whole column of times, choose how to round, and copy the result to Excel or Sheets. Free, no sign-up, and it runs in your browser.
Short answer: divide the minutes by 60. 45 minutes is 0.75 hours, 20 minutes is 0.33 and 7:45 is 7.75. For more conversions, see the minutes in decimal chart.
Minutes can go past 59 (90 minutes works). Leave hours empty to convert minutes alone.
0:20 (20 min) in decimal hours
Exact: 0.3333 hours. Rule: Decimals.
| Rule | Decimal hours | Difference from exact |
|---|---|---|
| 0.3333 | none | |
| 0.33 | -0.2 min | |
| 0.30 | -2 min | |
| 0.25 | -5 min | |
| 0.25 | -5 min | |
| 0.40 | +4 min |
Runs in your browser. Nothing you type is sent anywhere. No sign-up.
Minutes to decimal chart (1 to 60 minutes)
Each value is calculated as minutes / 60, not typed in by hand. Highlighting the 20 minute row from your last conversion.
| Min | 2 d.p. | 3 d.p. | Exact |
|---|---|---|---|
| 1 | 0.02 | 0.017 | 0.0167 |
| 2 | 0.03 | 0.033 | 0.0333 |
| 3 | 0.05 | 0.050 | 0.0500 |
| 4 | 0.07 | 0.067 | 0.0667 |
| 5 | 0.08 | 0.083 | 0.0833 |
| 6 | 0.10 | 0.100 | 0.1000 |
| 7 | 0.12 | 0.117 | 0.1167 |
| 8 | 0.13 | 0.133 | 0.1333 |
| 9 | 0.15 | 0.150 | 0.1500 |
| 10 | 0.17 | 0.167 | 0.1667 |
| 11 | 0.18 | 0.183 | 0.1833 |
| 12 | 0.20 | 0.200 | 0.2000 |
| 13 | 0.22 | 0.217 | 0.2167 |
| 14 | 0.23 | 0.233 | 0.2333 |
| 15 | 0.25 | 0.250 | 0.2500 |
| 16 | 0.27 | 0.267 | 0.2667 |
| 17 | 0.28 | 0.283 | 0.2833 |
| 18 | 0.30 | 0.300 | 0.3000 |
| 19 | 0.32 | 0.317 | 0.3167 |
| 20 | 0.33 | 0.333 | 0.3333 |
| Min | 2 d.p. | 3 d.p. | Exact |
|---|---|---|---|
| 21 | 0.35 | 0.350 | 0.3500 |
| 22 | 0.37 | 0.367 | 0.3667 |
| 23 | 0.38 | 0.383 | 0.3833 |
| 24 | 0.40 | 0.400 | 0.4000 |
| 25 | 0.42 | 0.417 | 0.4167 |
| 26 | 0.43 | 0.433 | 0.4333 |
| 27 | 0.45 | 0.450 | 0.4500 |
| 28 | 0.47 | 0.467 | 0.4667 |
| 29 | 0.48 | 0.483 | 0.4833 |
| 30 | 0.50 | 0.500 | 0.5000 |
| 31 | 0.52 | 0.517 | 0.5167 |
| 32 | 0.53 | 0.533 | 0.5333 |
| 33 | 0.55 | 0.550 | 0.5500 |
| 34 | 0.57 | 0.567 | 0.5667 |
| 35 | 0.58 | 0.583 | 0.5833 |
| 36 | 0.60 | 0.600 | 0.6000 |
| 37 | 0.62 | 0.617 | 0.6167 |
| 38 | 0.63 | 0.633 | 0.6333 |
| 39 | 0.65 | 0.650 | 0.6500 |
| 40 | 0.67 | 0.667 | 0.6667 |
| Min | 2 d.p. | 3 d.p. | Exact |
|---|---|---|---|
| 41 | 0.68 | 0.683 | 0.6833 |
| 42 | 0.70 | 0.700 | 0.7000 |
| 43 | 0.72 | 0.717 | 0.7167 |
| 44 | 0.73 | 0.733 | 0.7333 |
| 45 | 0.75 | 0.750 | 0.7500 |
| 46 | 0.77 | 0.767 | 0.7667 |
| 47 | 0.78 | 0.783 | 0.7833 |
| 48 | 0.80 | 0.800 | 0.8000 |
| 49 | 0.82 | 0.817 | 0.8167 |
| 50 | 0.83 | 0.833 | 0.8333 |
| 51 | 0.85 | 0.850 | 0.8500 |
| 52 | 0.87 | 0.867 | 0.8667 |
| 53 | 0.88 | 0.883 | 0.8833 |
| 54 | 0.90 | 0.900 | 0.9000 |
| 55 | 0.92 | 0.917 | 0.9167 |
| 56 | 0.93 | 0.933 | 0.9333 |
| 57 | 0.95 | 0.950 | 0.9500 |
| 58 | 0.97 | 0.967 | 0.9667 |
| 59 | 0.98 | 0.983 | 0.9833 |
| 60 | 1.00 | 1.000 | 1.0000 |
Quarter-hour table (nearest 15 min)
| Minutes | Decimal hours |
|---|---|
| 0 to 7 min | 0.00 |
| 8 to 22 min | 0.25 |
| 23 to 37 min | 0.50 |
| 38 to 52 min | 0.75 |
| 53 to 60 min | 1.00 |
Tenth-hour table (nearest 6 min)
| Minutes | Decimal hours |
|---|---|
| 0 to 2 min | 0.0 |
| 3 to 8 min | 0.1 |
| 9 to 14 min | 0.2 |
| 15 to 20 min | 0.3 |
| 21 to 26 min | 0.4 |
| 27 to 32 min | 0.5 |
| 33 to 38 min | 0.6 |
| 39 to 44 min | 0.7 |
| 45 to 50 min | 0.8 |
| 51 to 56 min | 0.9 |
| 57 to 60 min | 1.0 |
7-minute rule table
| Minutes | Decimal hours |
|---|---|
| 0 to 7 min | 0.00 |
| 8 to 22 min | 0.25 |
| 23 to 37 min | 0.50 |
| 38 to 52 min | 0.75 |
| 53 to 60 min | 1.00 |
Minutes in decimal chart: 10, 15, 20, 30, 45 minutes
The rule is always minutes divided by 60. These are the conversions people look up most, with the working shown.
| Minutes | Working | Exact | 2 decimals |
|---|---|---|---|
| 5 minutes | 5 / 60 | 0.0833 | 0.08 |
| 10 minutes | 10 / 60 | 0.1667 | 0.17 |
| 15 minutes | 15 / 60 | 0.2500 | 0.25 |
| 20 minutes | 20 / 60 | 0.3333 | 0.33 |
| 30 minutes | 30 / 60 | 0.5000 | 0.50 |
| 40 minutes | 40 / 60 | 0.6667 | 0.67 |
| 45 minutes | 45 / 60 | 0.7500 | 0.75 |
| 50 minutes | 50 / 60 | 0.8333 | 0.83 |
| Time | Working | Decimal hours |
|---|---|---|
| 1 h 30 min (1:30) | 1 + 30 / 60 | 1.50 |
| 1 h 30 min (1:30) | 1 + 30 / 60 | 1.50 |
| 2 h 15 min (2:15) | 2 + 15 / 60 | 2.25 |
| 7 h 45 min (7:45) | 7 + 45 / 60 | 7.75 |
| 8 h 20 min (8:20) | 8 + 20 / 60 | 8.33 |
| 8 h 30 min (8:30) | 8 + 30 / 60 | 8.50 |
Need every minute from 1 to 60? The full verified chart sits under the calculator, and you can print it.
How to convert minutes to decimal hours
An hour has 60 minutes, so one minute is 1/60 of an hour. To turn minutes into a decimal fraction of an hour, divide by 60.
- Minutes only: divide by 60. 20 minutes is 20 / 60 = 0.3333 hours.
- Hours and minutes: keep the hours, divide the minutes by 60, and add. 7:45 is 7 + 45 / 60 = 7.75.
- Decimal back to time: keep the whole hours and multiply the decimal part by 60. 7.75 is 7 hours and 0.75 x 60 = 45 minutes.
Why 1 minute is 0.0167, not 0.01. Decimal hours are based on 60, not 100. Treating the minutes as hundredths gives wrong results: 48 minutes is 0.80 hours (48 / 60), not 0.48. On a timesheet that error adds up fast, which is why every value on this page is calculated, not typed in.
Tick Explain the math in the calculator to see these steps for your own numbers. To add up a whole week of punches first, use the timecard calculator; to get the time between two clock times, use the hour calculator.
Worked examples: invoice, payroll punch and 37.4 hours
A freelancer invoice at 85 per hour
Three tasks: 1:25, 0:50 and 2:10. That is 85 + 50 + 130 = 265 minutes, or 4:25, which is 4.4167 decimal hours.
- Exact total: 4.4167 h x 85 = 375.42.
- Each task rounded to 2 decimals first: 4.42 h x 85 = 375.70.
- Each task rounded up to the next tenth-hour: 4.6 h x 85 = 391.00.
Same work, three totals. Decide the rule before you send the invoice, and state it on the invoice.
A payroll punch with the 7-minute rule
Clocking in at 9:00 and out at 17:07 is 8 h 7 min. The 7-minute rule rounds it down to 8.00 hours. Out at 17:08 is 8 h 8 min and rounds up to 8.25 hours. One minute of difference moves the pay by a quarter hour, which is the price of simple rounding.
Converting a payroll figure back
Your system says you worked 37.4 hours. That is 37 hours and 0.4 x 60 = 24 minutes, so 37:24. At the end of the week, 37.4 is easier to multiply by a rate; 37:24 is easier to compare with a clock. To turn decimal hours into regular and overtime pay, try the overtime calculator.
7-minute rule and other timesheet rounding rules
Rounding is a policy choice, not a math fact. The calculator shows the exact value next to each rule so you can see what the rule costs or gains.
- Exact or 2 to 3 decimals. Best when you are the one billing and want to be able to defend the number. 1 minute is 0.0167 h, which is 0.02 at two decimals and 0.017 at three, so rounding each line to two decimals can drift a little over many lines.
- Nearest tenth-hour (6 minutes). Common in legal and consulting work. Each step is 0.1 h.
- Quarter-hour and the 7-minute rule. The 7-minute rule is the usual way to round to the nearest quarter hour: 1 to 7 minutes past the quarter round down, 8 to 14 round up. On whole minutes it gives the same result as nearest quarter-hour. Across the 15 possible remainders, the minutes lost to rounding down (0 to 7 adds up to 28) equal the minutes gained by rounding up (7 down to 1 adds up to 28), so it is neutral on average if punches are spread evenly.
- Round up billing. Always rounds to the next tenth-hour. It is a pricing choice, not a neutral rounding rule: on evenly spread entries it adds about 2.5 minutes per entry in your favour, so agree it with the client.
Payroll in the US (last reviewed October 2026). The Department of Labor says in 29 CFR 785.48 that rounding start and stop times to the nearest 5 minutes, one-tenth or one-quarter of an hour is acceptable for enforcement purposes, as long as it is used so that it does not, over a period of time, fail to compensate employees for all the time they have actually worked. The rule is about being neutral over time, not about a fixed 7 minutes. See the regulation text. This is a general explanation, not legal advice, and rules outside the US differ.
Convert time to decimal in Excel and Google Sheets
Spreadsheets store a time as a fraction of a day (7:45 is 0.3229), which is why you multiply by 24 to get hours. Copy the formula that matches your column.
Time (7:45) to decimal hours
=A1*24A1 holds a real time value. Format the result cell as Number, not Time.
Example: A1 = 7:45 gives 7.75
Time to decimal, rounded to 2 places
=ROUND(A1*24,2)Use 3 instead of 2 for three decimals.
Example: A1 = 8:20 gives 8.33
Minutes (a plain number) to decimal hours
=A1/60For a column that holds minutes as numbers, such as 45 or 90.
Example: A1 = 20 gives 0.3333
Hours in A, minutes in B
=A1+B1/60When hours and minutes sit in two separate columns.
Example: A1 = 2, B1 = 15 gives 2.25
Time to nearest quarter-hour
=MROUND(A1*24,0.25)MROUND rounds halves up, so 7 min 30 s rounds to the next quarter.
Example: A1 = 7:38 gives 7.75
Time with the 7-minute rule
=INT((ROUND(A1*1440,0)+7)/15)/41 to 7 minutes past a quarter round down, 8 to 14 round up.
Example: A1 = 7:08 gives 7.25, A1 = 7:07 gives 7
Round up to the next tenth-hour
=CEILING(A1*24,0.1)Common in legal and consulting billing in 6-minute steps.
Example: A1 = 1:01 gives 1.1
Decimal hours (7.75) back to h:mm text
=TEXT(A1/24,"[h]:mm")The [h] keeps counting past 24 hours.
Example: A1 = 7.75 gives 7:45
Decimal hours back to a time value
=A1/24Then format the cell as [h]:mm so it can still be summed.
Example: A1 = 7.75 gives 7:45
Decimal hours to minutes
=A1*60Plain number of minutes.
Example: A1 = 0.75 gives 45
Minutes to decimal FAQ
How do I convert minutes to decimal hours?
Divide the minutes by 60. 45 minutes is 45 / 60 = 0.75 hours. 20 minutes is 20 / 60 = 0.3333 hours, usually written 0.33. If you also have whole hours, keep them and add the decimal: 2 hours 15 minutes is 2 + 15/60 = 2.25.
What is 20 minutes in decimal (and 10, 15, 30, 40, 45 minutes)?
10 minutes is 0.17, 15 minutes is 0.25, 20 minutes is 0.33, 30 minutes is 0.50, 40 minutes is 0.67 and 45 minutes is 0.75 hours, rounded to two places. The exact values for 10, 20 and 40 minutes repeat forever (0.1667, 0.3333, 0.6667), which is why the rounding rule you use matters.
How do I convert hours and minutes like 7:45 to decimal hours?
Keep the hours and divide the minutes by 60, then add. 7:45 is 7 + 45/60 = 7.75. 8:20 is 8 + 20/60 = 8.3333, or 8.33 to two decimals. The calculator above does this as you type, and the Bulk paste tab does it for a whole column.
How do I convert decimal hours back to hours and minutes?
Keep the whole number as hours and multiply the decimal part by 60 to get minutes. 7.75 hours is 7 hours and 0.75 x 60 = 45 minutes, so 7:45. 2.4 hours is 2 hours and 0.4 x 60 = 24 minutes, so 2:24. Use the Decimal to time switch in the calculator.
Why is 1 minute 0.0167 hours and not 0.01?
An hour has 60 minutes, not 100. One minute is 1/60 of an hour, which is 0.016666... or 0.0167 rounded. Reading the minutes as hundredths of an hour (so 1 minute as 0.01 or 48 minutes as 0.48) is the most common mistake on timesheets, and it is wrong: 48 minutes is 0.80 hours.
How do I convert time to decimal in Excel or Google Sheets?
If the cell holds a real time such as 7:45, multiply by 24 and format the result as Number: =A1*24 gives 7.75. If the cell holds minutes as a plain number, use =A1/60. To go back, =TEXT(A1/24,"[h]:mm") turns 7.75 into 7:45. The Excel and Sheets formulas section on this page has copy buttons for each case, including rounding.
Do payroll systems use decimal hours, and how should I round them (nearest 6 minutes, quarter hour, 7-minute rule)?
Most payroll and billing systems store time as decimal hours because it multiplies cleanly by an hourly rate. For employees in the US, the Department of Labor accepts rounding to the nearest 5 minutes, tenth of an hour or quarter hour, provided it does not, over time, shortchange employees (29 CFR 785.48). The 7-minute rule is the usual way to apply quarter-hour rounding: 1 to 7 minutes round down, 8 to 14 round up. Clients and law firms often bill in 6-minute tenth-hour steps and round up. Check your own policy, contract or local law, as this is not legal advice.
What is the difference between decimal hours and a decimal clock?
Decimal hours keep the normal 60-minute hour and just write the fraction as a decimal, so 7:45 becomes 7.75. A decimal clock is a different idea: a day split into 10 hours of 100 minutes, tried briefly in France in 1793 and not in use today. People who search for a decimal clock calculator almost always mean decimal hours, which is what this page converts. Some time clocks also show hundredths of an hour on the display, which is again decimal hours.
Can I convert a whole column of times to decimal at once?
Yes. Open the Bulk paste tab, paste a column of times such as 7:42, 8h15m, 0:50, 45 min or 1.25h, and you get a decimal column with a total row. Copy it as tab-separated text to paste straight into Excel or Google Sheets, or download a CSV. It all runs in your browser.