The fastest way to convert minutes to hours in Excel

To convert minutes to hours in Excel, divide the minutes value by 60. If your minutes are in cell A1, type =A1/60 in the cell where you want the result. Excel will show the decimal equivalent — so 90 minutes becomes 1.5 hours.

This works because there are 60 minutes in an hour, so dividing any minute count by 60 gives you the hour equivalent. The formula works the same way whether your minutes are whole numbers (like 120) or already decimals (like 90.5).

If you have many rows of minutes to convert, you can enter the formula once and then copy it down to all the other cells. Click the cell with your formula, then drag the small square at the bottom-right corner down to cover all rows that need conversion.

Key Takeaways

  • The basic formula to convert minutes to hours is =A1/60, where A1 is the cell containing your minutes.
  • To display hours and minutes separately (like "1:30" instead of "1.5"), format the result as time using the Format Cells menu.
  • You can copy a formula down to multiple rows by selecting the cell and dragging the fill handle to the cells below.
  • If you need to convert time that is already formatted as hours and minutes, use the HOUR and MINUTE functions to extract each part separately.

Formatting the result to show hours and minutes together

When you divide minutes by 60, Excel shows a decimal number — 1.5 for 90 minutes. If you want to display it as "1:30" (one hour, 30 minutes) instead, you need to format the cell as time.

Right-click the cell with your result and select Format Cells. In the window that opens, click the Number tab, then select Time from the Category list on the left. Choose the format that shows hours and minutes (usually listed as [h]:mm or similar). Click OK, and your decimal will now display as a time.

The square brackets around the h — [h]:mm — matter if your total is more than 24 hours. Without them, Excel will only show the hours past the last full day (so 25 hours would show as 1:00). With the brackets, it shows the full hour count.

Converting time that is already formatted as hours and minutes

If your data is already in time format — like a cell showing "2:30" (2 hours, 30 minutes) — you cannot straightforward divide by 60. Instead, use the HOUR and MINUTE functions to extract each part, then combine them into a decimal.

The formula is =HOUR(A1) + MINUTE(A1)/60. This takes the hours from the time in A1, adds the minutes divided by 60, and gives you the total in decimal form. So "2:30" becomes 2.5.

If you want the result as a decimal with many places (for example, to calculate pay or track time precisely), this method is more accurate than trying to convert a formatted time cell directly.

Using a formula to convert minutes and show the result as decimal hours

The simplest approach for most work is to keep the result as a decimal. Create a column for your minutes, then add a column next to it with the formula =A1/60 (or whatever row you are working in).

This decimal format is useful if you are calculating pay (hourly rate × hours worked), tracking time for billing, or feeding the numbers into other calculations. Many payroll and time-tracking systems expect hours as decimals rather than as formatted time.

If you need to round the result — for example, to bill in quarter-hour increments — use the ROUND function: =ROUND(A1/60, 2). The 2 tells Excel to round to two decimal places, so 1.567 becomes 1.57.

Converting hours back to minutes if you need to

If you have hours in decimal form and need to convert back to minutes, multiply by 60. The formula is =A1*60. So 1.5 hours becomes 90 minutes.

This is useful if you have calculated total hours but need to report the result in minutes, or if you are working with a system that requires minutes as input.

Handling time data from timesheets or time-tracking software

If you are importing time data from a timesheet or time-tracking app, the format may vary. Some systems export time as a decimal (1.5), some as formatted time (1:30), and some as text that looks like time but is not actually formatted as time.

If a formula does not work, the data is probably text. Select the column, go to Data in the menu, click Text to Columns, and click Finish without changing any settings. This converts text that looks like time into actual time format, and then your formulas will work.

If you are regularly importing the same format, you can set up a formula once and reuse it each time you get new data. Save the spreadsheet as a template so you do not have to rebuild it.

Frequently Asked Questions

Why does my formula show a decimal instead of hours and minutes?

Excel is showing the raw number. To display it as time, right-click the cell, select Format Cells, choose Time from the Category list, and pick a format that shows hours and minutes. The number itself is correct — only the display changes.

How do I convert 90 minutes to 1 hour and 30 minutes in Excel?

Divide 90 by 60 to get 1.5, then format the cell as time. Right-click, select Format Cells, choose Time, and pick [h]:mm format. The result will display as 1:30. The brackets may support hours over 24 display correctly.

Can I convert a column of minutes all at once?

Yes. Enter the formula =A1/60 in cell B1, then click B1 and drag the small square at the bottom-right corner down to cover all rows you need. Excel copies the formula and adjusts the cell reference for each row automatically.

What if my time data is text, not a time format?

Formulas will not work on text. Select the column, go to Data > Text to Columns, and click Finish. This converts text that looks like time into actual time format. Then your conversion formulas will work.

How do I round hours to the nearest quarter hour?

Use =ROUND(A1/60, 2) to round to two decimal places, or =MROUND(A1/60, 0.25) to round to the nearest 0.25 (quarter hour). The MROUND function is cleaner if you are billing in quarter-hour increments.