Convert Minutes to Hours and Minutes in Excel (3 Easy Methods)

Converting minutes to hours and minutes in Excel is simple once you know how Excel stores time internally. Here are three reliable methods.

Method 1: Division (Quickest)

Excel stores time as a fraction of 24 hours. To convert minutes to an Excel time value:

=A2/1440

Then format the cell as h:mm (Custom number format). For example, 90 minutes → 1:30.

Method 2: TEXT Function (Display Only)

Use TEXT to return a formatted string directly:

=TEXT(A2/1440,"h:mm")

Output: "1:30" as text. Good for display, but cannot be used in further calculations.

Method 3: INT and MOD (Separate Hours and Minutes)

To get hours and minutes as separate numbers:

Hours:   =INT(A2/60)
Minutes: =MOD(A2,60)

Then combine with TEXT:

=INT(A2/60)&" hrs "&MOD(A2,60)&" mins"

Output: "1 hrs 30 mins"

Convert Large Values (Over 24 Hours)

For totals over 24 hours (e.g., project tracking), use the custom format [h]:mm — the square brackets prevent the hour from resetting at 24.

FAQ

How do I convert minutes to hours in Excel?

Divide by 60 for decimal hours (=A2/60), or divide by 1440 and format as h:mm for hours:minutes display.

How do I show time as 1h 30m in Excel?

=INT(A2/60)&"h "&MOD(A2,60)&"m"

Why does Excel show #### when I enter time?

The column is too narrow. Widen it, or the value is negative (Excel can't display negative times by default).