To convert minutes to decimal hours, divide the number of minutes by 60. For example, 30 minutes ÷ 60 = 0.5 hours, and 45 minutes ÷ 60 = 0.75 hours. This works because one hour contains 60 minutes.
This simple conversion helps you record time on timesheets, track projects, and calculate hourly charges. Below, you’ll find the formula, examples, a conversion chart, and instructions for Excel.
What Are Decimal Hours?
Decimal hours show time as a number of hours with a decimal part.
For example, 1 hour and 30 minutes becomes 1.5 hours. The whole number represents one complete hour, while 0.5 represents half an hour.
Decimal hours and hours-and-minutes notation are different:
Hours and MinutesDecimal Hours1 hour 15 minutes1.251 hour 30 minutes1.501 hour 45 minutes1.752 hours 30 minutes2.50
1.30 decimal hours does not mean 1 hour and 30 minutes. It means 1 hour and 18 minutes, because 0.30 × 60 = 18.
Minutes to Decimal Hours Formula
Use this formula when you have a total number of minutes:
Decimal hours = Total minutes ÷ 60
For example, to convert 90 minutes:
90 ÷ 60 = 1.5 hours
If your time already includes separate hours and minutes, use:
Decimal hours = Hours + (Minutes ÷ 60)
For 2 hours and 45 minutes:
2 + (45 ÷ 60) = 2.75 hours
How to Convert Minutes to Decimal Hours Step by Step
Step 1: Find Your Total Minutes
Start with the duration you want to convert. For this example, use 135 minutes
Step 2: Divide by 60
Divide the minutes by the number of minutes in an hour:
135 ÷ 60 = 2.25
Step 3: Label the Answer
The result is 2.25 hours, which is the same as 2 hours and 15 minutes.
Keep the full result while doing further calculations. Round your final answer only when needed.
Minutes to Decimal Hours Conversion Chart
Use this chart to check common time conversions.
MinutesDecimal Hours10.016750.0833100.1667150.2500200.3333250.4167300.5000350.5833400.6667450.7500500.8333550.9167601.0000751.2500901.50001202.0000
Values are rounded to four decimal places where necessary.
Examples of Converting Minutes to Decimal Hours
Convert 20 Minutes to Decimal Hours
20 ÷ 60 = 0.3333… hours
Rounded to two decimal places, this is 0.33 hours.
Convert 75 Minutes to Decimal Hours
75 ÷ 60 = 1.25 hours
So, 75 minutes equals 1 hour and 15 minutes, or 1.25 decimal hours.
Convert 8 Hours and 20 Minutes to Decimal Hours
First, convert the minutes:
20 ÷ 60 = 0.3333…
Then add the whole hours:
8 + 0.3333… = 8.3333… hours
Rounded to two decimal places, the answer is 8.33 hours.
How to Use Decimal Hours for Time Tracking
Decimal hours make it easier to multiply a duration by an hourly rate.
Suppose you complete a project in 3 hours and 45 minutes, and your rate is $20 per hour.
Convert the time first:
3 + (45 ÷ 60) = 3.75 hours
Then multiply by the rate:
3.75 × $20 = $75
The charge for this example is $75, before any other adjustments.
For timesheets, check whether the system expects decimal hours, such as 3.75, or hours and minutes, such as 3:45.
How to Convert Minutes to Decimal Hours in Excel
The formula depends on how your time is stored.
If the Cell Contains a Number of Minutes
If cell A2 contains 90, enter:
=A2/60
The result is 1.5.
If Hours and Minutes Are in Separate Cells
If A2 contains 2 hours and B2 contains 45 minutes, enter:
=A2+B2/60
The result is 2.75.
If the Cell Contains an Excel Time Value
If A2 contains a valid Excel time value displayed as 2:45, enter:
=A2*24
Format the result cell as Number or General. Excel stores time as a fraction of a day, so multiplying by 24 converts it to decimal hours.
This method requires a numeric Excel time value; text that only looks like a time may need conversion first.
How to Convert Decimal Hours Back to Minutes
To convert decimal hours into total minutes, multiply by 60:
Total minutes = Decimal hours × 60
For example:
2.75 × 60 = 165 minutes
To show the answer as hours and minutes, keep the whole hours and multiply only the decimal part:
0.75 × 60 = 45 minutes
So, 2.75 hours = 2 hours and 45 minutes.
Common Mistakes to Avoid
- Dividing by 100: Divide minutes by 60 because an hour contains 60 minutes.
- Treating minutes as decimal digits: 4 hours and 30 minutes is 4.5 hours, not 4.30 hours.
- Rounding each entry too early: Add the original durations before rounding the final total where possible.
- Using the wrong Excel formula: Divide numeric minutes by 60; multiply a valid Excel time value by 24.
For example, three 20-minute tasks total exactly one hour. If you round each task to 0.33 hours first, their sum becomes 0.99 hours.
Frequently Asked Questions
How Do You Convert 30 Minutes to Decimal Hours?
Divide 30 by 60. The answer is 0.5 hours, or half an hour.
What Is 45 Minutes in Decimal Hours?
45 ÷ 60 = 0.75 hours.
Is 15 Minutes Equal to 0.15 Hours?
No. 15 minutes equals 0.25 hours. A duration of 0.15 hours equals 9 minutes.
How Many Minutes Are in 0.1 Hours?
Multiply 0.1 by 60. The answer is 6 minutes.
What Is 7 Hours and 30 Minutes in Decimal Hours?
Calculate 7 + (30 ÷ 60). The answer is 7.5 hours.
Should I Round Decimal Hours to Two Decimal Places?
Use the precision required by your timesheet or calculation. If two decimal places are needed, keep the full value during calculations and round the final result.
2 Comments
I love 😘 this 💕 😍..
Leave a Comment