30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / How to Convert Minutes into Hours & Minutes (HH:MM) in Excel (Formula)
By Puneet Gogia (Microsoft MVP)

How to Convert Minutes into Hours & Minutes (HH:MM) in Excel (Formula)

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Excel stores time as a fraction of a day, so converting minutes means dividing by 1440 — the minutes in a day — then formatting the result: =A1/(24*60), then Ctrl+1 → Custom and enter [h]:mm. The square brackets matter: without them, anything over 24 hours wraps around, so 1500 minutes shows as 1:00 instead of 25:00.

The TEXT function does both steps at once if you’d rather not change the cell format: =TEXT(A1/(24*60),"[h]:mm"), though the result is text and can’t be summed afterwards.

For a plain decimal number instead of a time value, divide by 60: =A1/60 turns 90 minutes into 1.5 hours — useful for timesheets and billing, and note the .5 is half an hour, not fifty minutes. =CONVERT(A1,"mn","hr") gives the same decimal result.

And to split the total into separate whole numbers, use =INT(A1/60) for the hours and =MOD(A1,60) for the leftover minutes.

To convert minutes to hours and minutes (HH:MM) in Excel, you need to use a formula where you divide the number of minutes by (24*60). As (24*60) is the total number of minutes in a day, it returns a number with decimals, which is the part of a day those minutes make (150 minutes is 0.104 of a day).

For converting that number into hours and minutes format, you need to apply [h]:mm in the custom formatting.

convert-minutes-into-hours

Formula to Convert Minutes into Hours and Minutes

You can use the below steps:

  1. First, in cell B1, refer to cell A1 where you have the minutes value.
  2. After that, type the division operator, and then enter an opening parenthesis.
  3. Now, enter 24, and then enter the multiply operator.
  4. Next, enter 60, close the parenthesis, and hit Enter to get the result.

Once you hit Enter, you will get the minutes as a part of a day in the cell (like 0.104166667 for 150 minutes).

formula-to-convert-minutes-into-hours

The next thing is to change the format of the cells. For this, select the cell and open the Format Cells dialog box using the keyboard shortcut Ctrl + 1.

change-the-cell-format

Now from here, click on the Custom category, and enter the format [H]:mm into the Type box.

change-cell-format-to-minutes

In the end, click OK to apply the format.

=A1/(24*60)

With [H]:mm, 150 minutes shows as 2:30. The square brackets around h let the hours go past 24, so 1530 minutes shows as 25:30. With h:mm (no brackets), it would show 1:30, as Excel drops the full day.

How does this Formula work?

In this formula, we have used 24*60 which returns the total number of minutes in a day (24 hours X 60 minutes = 1440 minutes).

how-formula-works

After that, when you divide the number of minutes you have by it, it returns the days, which is equivalent to the number of minutes that you have.

returns-the-days-equivalent-to-minutes

Now, to show these days as hours and minutes, you need to use the [h]:mm format.

Using TEXT Function

If you don’t want to change the formatting of the cell, you can use the TEXT function to apply the time format to the value within the formula.

text-function-to-add-time

This formula exactly works like the earlier method. The only difference is that you are using TEXT to format the result value.

=TEXT(A1/(24*60),"[h]:mm")

Keep in mind that TEXT returns text, so you can’t add up these results with SUM.

Convert Minutes to Hours and Minutes (As a Number)

You can also use a formula where you divide the number of minutes by 60.

minutes-to-hours-as-numbers

This formula returns the hours as a decimal number, where the whole number is the hours and the decimal part is a fraction of an hour, not minutes. For example, 150 minutes returns 2.5, which is 2 hours and 30 minutes.

=A1/60

Convert Function

There’s one more function in Excel that you can use to convert minutes to hours, and that’s CONVERT.

convert-function

In CONVERT, you need to refer to the minute value, the original unit of the value (you need to specify minutes “mn”), and then the conversion unit (specify “hr” for hours).

=CONVERT(A1,"mn","hr")

Like dividing by 60, CONVERT returns decimal hours (2.5 for 150 minutes).

Show Hours and Minutes as Words

If you want a result like “2 hours 30 minutes”, use INT to get the full hours and MOD to get the minutes left over:

=INT(A1/60)&" hours "&MOD(A1,60)&" minutes"

Convert Hours and Minutes Back to Minutes

To go the other way, multiply a time value (like 2:30 in A1) by 1440, the number of minutes in a day, and format the result as General:

=A1*1440

Frequently Asked Questions

Why does my result show 1:30 instead of 25:30?

The cell uses h:mm, which resets after 24 hours. Use [H]:mm with the square brackets to show the total hours.

Can I add up the converted times?

Yes, if you used the =A1/(24*60) formula with the [H]:mm format. SUM adds them, and you should format the total with [H]:mm too. Results from TEXT are text and can’t be added.

What is 1440 in Excel time formulas?

It’s the number of minutes in a day (24 × 60). Dividing minutes by 1440 gives Excel’s time value, and multiplying a time by 1440 gives minutes.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment