By Intious · Updated October 4, 2026
To convert minutes to decimal hours in Excel, divide by 60: =A2/60. If A2 contains a numeric Excel time such as 1:30, use =A2*24. Format the result as Number. Both examples produce 1.5 hours when the input represents 90 minutes.
Only need one conversion? Use the decimal hours converter. For a column of durations, use the bulk time converter and rounding checker.
Choose the right Excel formula
| Input | Formula | Result in hours |
|---|---|---|
| 90 minutes as a number in A2 | =A2/60 | 1.5 |
| 1:30 as numeric Excel time in A2 | =A2*24 | 1.5 |
| 8 hours in A2 and 30 minutes in B2 | =A2+B2/60 | 8.5 |
| 27:30 as numeric duration in A2 | =A2*24 | 27.5 |
Convert a column of minutes step by step
- Put the minute counts in column A. For example, enter 45, 90 and 125 in A2:A4.
- Enter
=A2/60in B2 and fill the formula down to B4. - Format column B as Number. The results are 0.75, 1.5 and 2.083333… hours.
- For the complete duration, use
=SUM(A2:A4)/60. The 260 minutes equal 4.333333… hours.
Showing two decimal places changes the display, while ROUND changes the calculated value used later. Keep the original durations when checking a payroll import. A display of 2.08 hours is a rounded representation of 125 minutes.
Convert hours and minutes stored as Excel time
Excel stores a numeric time as part of a day. Multiplying that value by 24 expresses it in hours. For a duration displayed as 8:30, =A2*24 gives 8.5. Do not divide this input by 60: the cell already contains a day fraction, not a count of minutes.
To total numeric time durations in A2:A6, use =SUM(A2:A6)*24 and format the result as Number. If hours and minutes are in separate numeric columns, add hours to minutes divided by 60 instead.
Why does the result look like another time?
The result cell may still use a Time format. Change it to Number or General. Formatting determines what you see; it does not change the stored value. If a pasted value looks like 1:30 but behaves inconsistently, check =ISNUMBER(A2). FALSE means the cell is not numeric. Resolve the imported text format before applying a numeric-duration formula.
A value typed as 1.30 is a decimal number, not one hour and thirty minutes. It represents 1 hour and 18 minutes when measured in hours. The decimal-time import checklist helps separate format mistakes from arithmetic mistakes.
Keep totals over 24 hours visible
Display a numeric duration total using the custom format [h]:mm. Ordinary clock formats can show only the remainder after a full day. A 27-hour, 30-minute duration should remain visible as 27:30 and convert to 27.5 hours. Do not use a clock-hour component as a substitute for total elapsed hours.
Test one duration longer than a day before converting an entire timesheet. A correct-looking short entry does not prove that multi-day totals will be handled correctly.
Avoid rounding each row too early
Twelve entries of five minutes total exactly one hour. Five minutes is 0.083333… hours; rounding each entry to 0.08 and adding the results gives 0.96. For a pure duration total, add the original minutes first and round the final result only when needed. A payroll policy may specify a particular rounding method; record that method separately from the conversion.
Compare both methods in the timesheet rounding checker, or read how to sum times without rounding errors.
Convert decimal hours back to hours and minutes in Excel
If A2 contains decimal hours, use =A2/24 and format the result as [h]:mm. An input of 8.5 displays as 8:30, and 27.5 displays as 27:30. The square brackets keep totals beyond 24 hours visible. This reverses the numeric-time-to-hours formula =A2*24.
For a reverse check without a spreadsheet, choose decimal input in the decimal hours converter. Remember that 1.30 decimal hours is 1:18, while 1:30 is 1.5 decimal hours. Formatting to minutes can hide remaining seconds; retain the original value for reconciliation.
If you need to calculate durations from start and finish timestamps, follow the Excel timesheet layout with unpaid breaks. For an online shared sheet, use the Google Sheets timesheet formulas.
Frequently asked questions
What is 30 minutes in decimal hours?
30 ÷ 60 = 0.5 hours. It is not 0.30 hours, which equals 18 minutes.
How do I convert 8 hours 45 minutes?
Calculate 8 + 45 ÷ 60 = 8.75 hours. With 8 in A2 and 45 in B2, use =A2+B2/60.
Can I round decimal hours to two places?
Yes. =ROUND(A2/60,2) rounds a minute count to two decimal places. Keep the unrounded source for totals and reconciliation. Number formatting alone can display two places without changing the stored result.
Why does multiplying by 24 give the wrong result?
Check the input type. Multiply by 24 only for numeric Excel time durations. A plain number of minutes needs division by 60. A cell containing a full date and time is not just an elapsed duration; calculate the difference between timestamps first.
Reference and related resources
Microsoft documents the time conversion model in Convert times and duration formatting in Add or subtract time in Excel. The examples above are Intious calculations.
- Decimal hours conversion chart
- Work hours calculator
- Monthly work-hours charts and downloadable tables
Read our methodology or report an error.