Time to decimal calculator: hours and minutes to decimal hours

Updated 22 November 2026 ยท ClearCost USA ยท 3 min read

To convert time to decimal hours, divide the minutes by 60 and add them to the hours: 7 hours 45 minutes = 7 + 45/60 = 7.75 hours. To go back, multiply the decimal part by 60: 6.4 hours = 6 hours 24 minutes. Payroll uses decimal hours because a rate times 7.75 is easy to multiply, while 7:45 is not.
Advertisement

Minutes to decimal conversion chart

Minutes to decimal hours

MinutesDecimalMinutesDecimalMinutesDecimal
10.02210.35410.68
20.03220.37420.70
30.05230.38430.72
40.07240.40440.73
50.08250.42450.75
60.10260.43460.77
70.12270.45470.78
80.13280.47480.80
90.15290.48490.82
100.17300.50500.83
110.18310.52510.85
120.20320.53520.87
130.22330.55530.88
140.23340.57540.90
150.25350.58550.92
160.27360.60560.93
170.28370.62570.95
180.30380.63580.97
190.32390.65590.98
200.33400.67601.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).
Advertisement

Common payroll conversions

Quick conversions

TimeDecimal hours
15 min0.25
20 min0.33
30 min0.50
40 min0.67
45 min0.75
7 h 30 min7.50
8 h 20 min8.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.

Advertisement

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?
Divide minutes by 60 and add to the hours: 5 hours 15 minutes = 5.25 hours.
What is 45 minutes in decimal?
0.75 hours.
What is 7 hours 30 minutes in decimal?
7.5 hours.
How do I convert decimal hours back to minutes?
Multiply the decimal part by 60: 0.4 hours = 24 minutes.
How do I convert time to decimal in Excel?
Multiply the time cell by 24 and format the result as a number, for example =A1*24.
What is 20 minutes as a decimal of an hour?
0.33 hours (20 / 60 = 0.3333).
How do I add up hours and minutes for a week?
Convert each day to decimal hours, add them, then round the total to two decimals. Or add hours and minutes separately and convert every 60 minutes into an extra hour before converting the leftover minutes.
Why does payroll use decimal hours?
Because pay = hours x rate is easy to calculate with decimals and avoids errors with minutes.
What is 8 hours 20 minutes in decimal?
8.33 hours.
What is 1 hour 10 minutes in decimal?
1.17 hours (10 / 60 = 0.1667, rounded).
How do I convert decimal hours to hours and minutes in Excel?
Divide the decimal by 24 and format the cell as [h]:mm, for example =A1/24. A value of 7.75 then shows as 7:45.
Is 7.5 hours the same as 7 hours 50 minutes?
No. 7.5 hours is 7 hours 30 minutes, because 0.5 of an hour is 30 minutes. Mixing up the two is a common payroll error.

Results are estimates for information only, not financial advice. Read the full disclaimer.

More free calculators

Advertisement