Time to decimal calculator: hours and minutes to decimal hours
Minutes to decimal conversion chart
Minutes to decimal hours
| Minutes | Decimal | Minutes | Decimal | Minutes | Decimal |
|---|---|---|---|---|---|
| 1 | 0.02 | 21 | 0.35 | 41 | 0.68 |
| 2 | 0.03 | 22 | 0.37 | 42 | 0.70 |
| 3 | 0.05 | 23 | 0.38 | 43 | 0.72 |
| 4 | 0.07 | 24 | 0.40 | 44 | 0.73 |
| 5 | 0.08 | 25 | 0.42 | 45 | 0.75 |
| 6 | 0.10 | 26 | 0.43 | 46 | 0.77 |
| 7 | 0.12 | 27 | 0.45 | 47 | 0.78 |
| 8 | 0.13 | 28 | 0.47 | 48 | 0.80 |
| 9 | 0.15 | 29 | 0.48 | 49 | 0.82 |
| 10 | 0.17 | 30 | 0.50 | 50 | 0.83 |
| 11 | 0.18 | 31 | 0.52 | 51 | 0.85 |
| 12 | 0.20 | 32 | 0.53 | 52 | 0.87 |
| 13 | 0.22 | 33 | 0.55 | 53 | 0.88 |
| 14 | 0.23 | 34 | 0.57 | 54 | 0.90 |
| 15 | 0.25 | 35 | 0.58 | 55 | 0.92 |
| 16 | 0.27 | 36 | 0.60 | 56 | 0.93 |
| 17 | 0.28 | 37 | 0.62 | 57 | 0.95 |
| 18 | 0.30 | 38 | 0.63 | 58 | 0.97 |
| 19 | 0.32 | 39 | 0.65 | 59 | 0.98 |
| 20 | 0.33 | 40 | 0.67 | 60 | 1.00 |
Decimal = minutes / 60, rounded to two places.
How to convert time to decimal in Excel
- If A1 holds a time like 7:45, use =A1*24 and format the cell as Number: result 7.75 (Excel stores times as fractions of a day).
- For hours in A1 and minutes in B1: =A1+B1/60.
- For a duration over 24 hours, format the source cell as [h]:mm before multiplying by 24.
- Decimal back to time: =A1/24, formatted as [h]:mm.
- Round to quarter hours: =MROUND(A1*24,0.25).
Common payroll conversions
Quick conversions
| Time | Decimal hours |
|---|---|
| 15 min | 0.25 |
| 20 min | 0.33 |
| 30 min | 0.50 |
| 40 min | 0.67 |
| 45 min | 0.75 |
| 7 h 30 min | 7.50 |
| 8 h 20 min | 8.33 |
| 37 h 30 min (week) | 37.50 |
Rounding rules for payroll
Many employers round time to the nearest tenth (6 minutes) or quarter hour (15 minutes). Federal rules allow rounding to 5, 6 or 15 minutes if it averages out fairly. Decimal rounding: keep two decimal places when multiplying by pay rates, or round minutes first and then convert. Totals for a week are easiest in the time card calculator, and yearly pay in the salary calculator.
Worked example
A week of 7:45, 8:20, 6:50, 8:00 and 7:35 equals 7.75 + 8.33 + 6.83 + 8.00 + 7.58 = 38.49 hours (38 hours 30 minutes, small differences come from rounding each day). At $21.50 an hour that is $827.54 gross pay. Billing by the hour works the same way for freelancers.
How we got these numbers
Conversions are minutes divided by 60. Rounding rules follow US Department of Labor guidance.
Figures were checked on 22 November 2026. Averages are estimates, not quotes or advice; rules and prices change, so confirm with the official source or a licensed professional before you act.
Sources and further reading
Questions people ask
How do I convert hours and minutes to decimal?
What is 45 minutes in decimal?
What is 7 hours 30 minutes in decimal?
How do I convert decimal hours back to minutes?
How do I convert time to decimal in Excel?
What is 20 minutes as a decimal of an hour?
How do I add up hours and minutes for a week?
Why does payroll use decimal hours?
What is 8 hours 20 minutes in decimal?
What is 1 hour 10 minutes in decimal?
How do I convert decimal hours to hours and minutes in Excel?
Is 7.5 hours the same as 7 hours 50 minutes?
Results are estimates for information only, not financial advice. Read the full disclaimer.