Excel Formula to Convert Minutes to Hours

Formulas & functions · Updated November 19, 2026

To convert a number of minutes in cell A2 to decimal hours in Microsoft Excel, divide by 60: =A2/60. For example, if A2 contains 135, the result is 2.25 hours; this is a numeric value you can use in further calculations.

The Basic Minutes-to-Hours Formula

There are 60 minutes in an hour, so dividing a minutes value by 60 gives the equivalent number of hours. The result may be a whole number or a decimal: 90 minutes becomes 1.5 hours, while 45 minutes becomes 0.75 hours. This is usually the right approach for calculating labor, tracking task time, or comparing durations as numbers.

With the number of minutes in A2, enter =A2/60 in another cell. If A2 contains 135, the formula returns 2.25. The cell reference makes the result update whenever the minutes in A2 change. To use a different location, replace A2 with the cell that contains your minutes, such as C5.

For a column of values, enter the formula beside the first minutes value, then copy or fill it down. Excel adjusts the relative reference for each row: a formula referring to A2 will refer to A3 on the next row. Check that the formula points to the intended minutes column before copying it across a larger table.

Why Dividing by 60 Works

The calculation is a unit conversion, not a special Excel time function. Since one hour contains 60 minutes, minutes divided by 60 gives hours. The decimal portion represents part of an hour: 0.5 is half an hour, 0.25 is 15 minutes, and 0.75 is 45 minutes. This representation is useful when you need to add, average, or multiply durations as ordinary numbers.

Keep the difference between a decimal hour and a clock-style duration in mind. A result of 2.5 means two and a half hours, or two hours and 30 minutes. It does not mean 2 hours and 5 minutes. If a report expects decimal hours, displaying 2.5 is appropriate; if readers expect a duration such as 2:30, use an Excel time value and a suitable number format instead.

Excel also has an internal system for storing times: a full day is represented by 1, and a time is stored as a fraction of a day. That is why a value entered as a time such as 2:30 is not the same kind of input as the integer 150. Choose the calculation based on what is actually in the source cell, not just on how the value looks on screen.

Enter and Copy the Formula

For a straightforward worksheet, set up one column for minutes and an adjacent column for the converted hours. For example, put task names in column A, minutes in column B, and decimal hours in column C. If minutes are in B2, enter the conversion in C2 and fill it down for the remaining records.

  1. Enter each duration as a number of minutes, such as 135, in the minutes column.
  2. Select the result cell beside the first entry and type the formula using that row’s minutes cell.
  3. Press Enter. Confirm that the result is plausible before filling the formula down.
  4. Copy or drag the fill handle down the result column. Check the last few rows to confirm the references moved with each row.
  5. Apply a Number format if you want consistent decimal places in the displayed results.

For instance, if B2 contains 135, the formula in C2 is =B2/60 and returns 2.25. If B3 contains 45, the formula copied to C3 becomes =B3/60 and returns 0.75. The calculation keeps full precision even if the displayed number format shows fewer decimal places.

Decimal Hours Versus an Hours-and-Minutes Display

Some readers want a mathematical number of hours; others want a duration that looks like a clock reading. These are different output formats. Decimal hours are convenient for arithmetic and many timesheet reports. A duration displayed as hours and minutes is often easier to scan when people are checking a schedule or elapsed time.

To create a time value from a numeric count of minutes, divide the minutes by the number of minutes in a day, which is 1,440. With the number of minutes in A2, use =A2/1440. If A2 contains 135, this produces an Excel time value equal to two hours and 30 minutes. Format the result cell as hours and minutes to display it as 2:30.

In Excel for Microsoft 365 on Windows, select the result cell and use Home > Number Format dropdown > More Number Formats. In the Format Cells dialog, choose Custom and enter [h]:mm as the type. The brackets around h tell Excel to show total elapsed hours rather than restarting the hour count at 24. For a duration under one day, a standard hours-and-minutes format may also appear to work, but the bracketed format is safer for totals that can exceed 24 hours.

Do not apply the hours-and-minutes format to a decimal-hours result and expect it to convert the decimal correctly. A numeric 2.5 formatted as a time is interpreted in Excel’s day-based time system, so it may display as a date or a very long duration rather than 2:30. Start with the correct calculation for the intended type of output, then format that result.

Worked Examples and Totals

Here are common values and their decimal-hour equivalents. Each result follows the same divide-by-60 rule:

  • 30 minutes is 0.5 hours.
  • 45 minutes is 0.75 hours.
  • 60 minutes is 1 hour.
  • 90 minutes is 1.5 hours.
  • 135 minutes is 2.25 hours.
  • 480 minutes is 8 hours.

To add converted values, put the decimal-hour results in a continuous range. If B2:B4 contain 90, 120, and 120 minutes, and C2:C4 contain their decimal-hour conversions (1.5, 2, and 2), the total in C5 can be calculated with =SUM(C2:C4). The formula returns 5.5 hours, which corresponds to 330 minutes. Make sure the cells being summed are numeric results rather than text that merely looks like numbers.

You can also total the minutes first and convert the total, or convert each row and sum the hours. For ordinary numeric values, both approaches produce the same mathematical result, aside from any rounding you deliberately apply to individual rows. If a report needs exact totals, avoid rounding each row prematurely; round only the final display or final total when the reporting requirement calls for it.

Rounding and Number Formatting

Excel can retain more decimal places than it displays. For example, a conversion may have a repeating decimal, while a cell formatted to show two decimal places presents a shorter number. Number formatting changes what is shown, not the underlying value. That distinction matters when later formulas use the result.

If you specifically need the calculated value rounded to two decimal places, and A2 contains minutes, use =ROUND(A2/60,2). For A2 equal to 125, the result is 2.08 hours because 125 divided by 60 is approximately 2.0833 and rounding to two decimal places gives 2.08. This is a different choice from merely formatting the unrounded result to show two decimals.

Use rounding only when it matches the purpose of the worksheet. If every task is rounded separately, the sum of those rounded rows can differ slightly from converting and rounding the combined minutes. For payroll or other formal records, follow the applicable employer or system rules for recording and rounding time; a spreadsheet formula alone does not determine those rules.

Common Input and Display Problems

A formula can be mathematically correct and still give an unexpected result if the input is not stored as assumed. These checks resolve many conversion issues:

  • The result looks like a date or time: The result cell may have a time or date format. Apply a Number format for decimal hours, or use the minutes-to-day conversion and a duration format if you want hours and minutes.
  • The source shows 2:30: Excel likely treats this as a time value, not the integer 150. For a time value in A2, decimal hours are obtained by multiplying the stored value by 24. With A2 entered as 2:30, =A2*24 returns 2.5.
  • The source is text: A number stored as text may not behave as expected in calculations. Check whether it is left-aligned or flagged as text, and convert it to a numeric value before relying on the result.
  • The value contains hours and minutes in separate columns: Do not divide only the minutes field by 60 and omit the hour field. First combine the two components into a total number of minutes, or calculate the total duration using a consistent time representation.
  • A total above 24 hours appears to wrap: If the result is an Excel duration, apply the custom format [h]:mm. Without brackets, hours may display as the hour of a time-of-day cycle instead of the total elapsed hours.

The multiplication case deserves special attention. With an Excel time value in A2 that represents 2 hours and 30 minutes, =A2*24 returns 2.5 decimal hours. This is not the correct formula for a cell containing the plain number 150; for numeric minutes, division by 60 is the direct conversion.

Choosing the Right Method

Decide what the result must mean before choosing a formula. If you are calculating decimal hours for analysis, billing summaries, or a numerical comparison, divide numeric minutes by 60. If you want an elapsed-time display such as 2:30, convert numeric minutes to a fraction of a day and apply a duration format. If the input is already an Excel time such as 2:30, multiply it by 24 to obtain decimal hours.

Use these quick checks when selecting a method:

  • Minutes are stored as a whole number: divide by 60 for decimal hours.
  • Minutes are stored as a whole number, but the display should be h:mm: divide by 1,440 and format as [h]:mm.
  • The cell already contains an Excel time value: multiply by 24 for decimal hours.
  • The value will be used in later arithmetic: keep the result numeric and avoid converting it to text just to add a label.

For example, adding the word hours to a result may make it easier to read, but it can make that cell less convenient for calculations. A clearer worksheet often keeps the numeric amount in one column and puts the unit in a column heading, such as Decimal hours. This also makes it easier to format, sort, and total the values consistently.

Frequently Asked Questions

What is the Excel formula for minutes to hours?
For a numeric number of minutes in A2, use =A2/60. If A2 is 135, the result is 2.25 decimal hours.

How do I convert 90 minutes to hours in Excel?
Put 90 in a cell and divide that cell by 60. The result is 1.5 hours, or one hour and 30 minutes. If you want the display 1:30, use the duration approach rather than displaying decimal hours as a clock time.

How do I show minutes converted to hours as hh:mm?
For a numeric minute count in A2, use =A2/1440 and format the result with [h]:mm. For 135 minutes, the displayed duration is 2:15.

Why does dividing a time such as 2:30 by 60 give the wrong answer?
Because an Excel time is stored as a fraction of a day, while the integer 150 represents a count of minutes. For an Excel time value in A2, multiply by 24 to get decimal hours. For a numeric minute count, divide by 60.

Can I convert minutes to whole hours?
Yes, but decide whether you want to round, truncate, or show only completed hours. Rounding can change the reported duration, so use it only when required. For a more informative result, retain decimal hours or display the duration as hours and minutes.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.