Minutes to Hours and Minutes Excel Formula

Updated 6 November 2026 · Standard formula, shown below

To convert a number of minutes into hours and remaining minutes in Excel, use the formula =INT(A1/60)&" hours and "&MOD(A1,60)&" minutes", where A1 contains the total minutes. This returns a text string like “2 hours and 30 minutes”. If you need a numeric result that Excel can use in further calculations, use =A1/1440 and format the cell as [h]:mm to display total hours and minutes.

Why Convert Minutes to Hours and Minutes?

Minutes often need to be presented in a human-readable format for timesheets, project tracking, payroll, or scheduling. A raw number like 150 minutes is less intuitive than “2 hours and 30 minutes.” Excel stores time as a fraction of a day, so the conversion requires either arithmetic (for text output) or cell formatting (for a true time value). Understanding both methods lets you choose the one that fits your workflow.

The Simple Formula: Text Output

The most direct formula splits the total minutes into whole hours and the remainder. It uses two built-in functions:

INT() – removes the decimal part, giving the whole number of hours.
MOD() – returns the remainder after division, giving the leftover minutes.

For a cell containing 150 minutes:

=INT(A1/60)&" hr "&MOD(A1,60)&" min"

This produces 2 hr 30 min. You can change the separators (e.g., “hours and”, “:”, or “h “) to match your preference. The ampersand (&) concatenates text and numbers; the numbers are automatically converted to text in the result.

Numeric Time Format: For Calculations

If you want the result as a real time value (so you can add or subtract it later), divide minutes by 1440 (the number of minutes in a day) and format the cell as a duration. For example, with 150 in A1:

=A1/1440

Then right-click the cell, choose Format Cells, select Custom, and enter [h]:mm. The cell will display 2:30. The square brackets around h allow hours to exceed 24 (e.g., 1500 minutes shows as 25:00). This is the correct approach when you need to perform arithmetic on the result, such as summing multiple durations.

Worked Example with Default Values

Suppose you have 50 minutes in cell A1. Using the text formula:

INT(50/60) = 0 (since 50 divided by 60 is 0.833, the integer part is 0).
MOD(50,60) = 50 (the remainder when 50 is divided by 60 is 50).
Concatenate: 0 hr 50 min.

Using the numeric method: 50/1440 = 0.0347222..., which formatted as [h]:mm displays 0:50. Both are correct; the text version is clearer for display, the numeric version is better for further calculations.

Common Mistakes and How to Avoid Them

Using HOUR() and MINUTE() on a raw number – These functions expect a time value, not a count of minutes. They will return 0 for any number less than 1 (since they read the fraction of a day). Only use them after dividing by 1440.
Forgetting the square brackets in [h]:mm – Without brackets, Excel resets hours at 24, so 25 hours shows as 1:00. Always include the brackets for durations.
Rounding the minutes – If you use ROUND() before splitting, you may lose accuracy. Only round at the final display stage if needed.
Negative minutes – The formulas work with negative numbers, but the text output will show a negative sign only on the hours (e.g., -1 hr 30 min). For a consistent sign, use =IF(A1<0,"-","")&INT(ABS(A1)/60)&... .

Alternatives: Using Excel’s Built-in Time Functions

If you already have a time value (e.g., from a formula like TIME(2,30,0)), you can extract hours and minutes with:

=HOUR(A1)&" hr "&MINUTE(A1)&" min"

But this only works if A1 is a true time (a fraction of a day). For a raw minute count, you must first divide by 1440. Another alternative is the TEXT() function:

=TEXT(A1/1440,"h\h m\m")

This formats the time as text directly, e.g., 2h 30m. It is shorter but less flexible for custom separators.

When to Use Which Method

Display only – Use the INT() and MOD() text formula. It is simple and does not require cell formatting.
Further arithmetic – Use =A1/1440 with [h]:mm formatting. This keeps the value numeric so you can sum, average, or compare.
Exporting to other systems – Text output is often easier to paste into reports or emails. Numeric time values may lose formatting when exported to CSV.
Large datasets – The text formula is fast and does not depend on cell formatting, which can be inconsistent across copied ranges.

Frequently Asked Questions

How do I convert minutes to hours and minutes in Excel without a formula?

You can divide the minutes by 1440 and then format the cell as [h]:mm. This does not require a formula if you type the division directly into the cell (e.g., =150/1440) and then apply the custom format. The cell will display 2:30.

Why does my formula show 0 hours for 90 minutes?

That happens if you use HOUR() on the raw number 90. Since 90 is not a time value (it is a count), Excel treats it as 90 days, and HOUR() returns 0 (the hour of midnight). Always divide by 1440 first to convert minutes to a time fraction.

Can I convert minutes to hours and minutes in Google Sheets the same way?

Yes, the formulas are identical. Google Sheets also uses the same INT(), MOD(), and HOUR() functions, and the custom format [h]:mm works the same. The only difference is the menu path for formatting, but the formula syntax is unchanged.

How do I convert a decimal like 2.5 hours to hours and minutes?

If you have hours as a decimal (e.g., 2.5), multiply by 60 to get minutes first: =A1*60. Then apply the same INT()/MOD() formula to that result. Alternatively, you can use =A1/24 and format as [h]:mm to get 2:30 directly.

What if my minutes are in text format, like “150 min”?

First extract the numeric part with =VALUE(SUBSTITUTE(A1," min","")) or =--LEFT(A1,FIND(" ",A1)-1). Then use that number in the conversion formulas. If the text is inconsistent, consider using Excel’s Text to Columns feature to split the number from the unit.

Does the formula work for negative minutes?

Yes, but the text output will place the minus sign only before the hours. For example, -90 gives -1 hr 30 min. To get a consistent sign, wrap the formula with IF(A1<0,"-","") and use ABS(A1) for the calculation.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.