Minutes to Hours Calculator in Excel

To convert minutes to hours in Excel, divide the number of minutes by 1440 (the number of minutes in a day) and format the result as a time, or divide by 60 and format as a number. This article explains the formulas, formatting, and common pitfalls so you can confidently handle any minute-to-hour conversion.

Formula

There are two standard formulas depending on the output you want:

• Decimal hours: hours = minutes / 60. This gives a number like 2.5 for 150 minutes.
• Hours and minutes (h:mm): time = minutes / 1440. Since Excel stores times as fractions of a day (1 day = 24 hours = 1440 minutes), dividing by 1440 converts minutes to a time value. Format the cell with the custom number format h:mm to display e.g., 2:30.

Both formulas are mathematically equivalent; the difference is only in how you format the result.

Worked Example

Using the default value of 150 minutes:

1. Decimal hours: =150/60 = 2.5 hours.
2. Time format: =150/1440 = 0.1041667 (as a fraction of a day). Format as h:mm → displays 2:30.

Both results are correct: 150 minutes equals 2.5 hours or 2 hours and 30 minutes.

How to Convert Minutes to Hours in Excel

Follow these steps for a clean conversion:

1. Enter your minutes in a column, say A1.
2. In B1, type =A1/60 for decimal hours, or =A1/1440 for time format.
3. If using the time formula, right-click the cell, choose Format Cells, go to the Number tab, select Custom, and type h:mm (or [h]:mm if you expect more than 24 hours).

Common Mistakes and How to Avoid Them

• Forgetting to format: If you use =A1/1440 and see a small decimal like 0.104, you haven’t applied the time format.
• Using 60 instead of 1440 for time: Dividing by 60 gives decimal hours, not a time value. If you then format as h:mm, you’ll get wrong results (e.g., 150/60=2.5 → formatted as 2:30? Actually 2.5 as a time is 2 days 12 hours, which displays as 12:00 if you use h:mm). Always use 1440 for time.
• Over 24 hours: Standard h:mm resets after 24 hours. Use [h]:mm to show total hours (e.g., 1500 minutes → 25:00).
• Negative minutes: Excel handles negative times only if you use the 1904 date system (File > Options > Advanced > “Use 1904 date system”). Otherwise, negative time displays as ####.

When to Use Each Formula

• Decimal hours are best for payroll, billing, or any calculation where you need to multiply by an hourly rate.
• h:mm format is best for schedules, timesheets, or when you want a human-readable duration like “2:30” without converting to 2.5.

You can also convert a time value (like 2:30) back to minutes by multiplying by 1440, or to decimal hours by multiplying by 24.

Alternatives to Manual Formulas

• CONVERT function: =CONVERT(A1,"mn","hr") converts minutes to decimal hours (note: it returns decimal hours, not a time format).
• Text functions: If you have a text string like “2h 30m”, you can parse it with LEFT, MID, and RIGHT, but it’s easier to use the formulas above.
• Paste Special: To convert a column of minutes to decimal hours without formulas, type 60 in a cell, copy it, select your minutes, right-click > Paste Special > Divide.

Frequently Asked Questions

How do I convert minutes to hours and minutes in Excel?

Divide minutes by 1440 and format the cell as h:mm. For example, =150/1440 with format h:mm shows 2:30.

Why does my time show as a decimal like 0.104?

That’s the raw fraction of a day. Apply a time format (like h:mm) via Format Cells > Number > Time, or use the custom format h:mm.

How do I show total hours over 24?

Use the custom format [h]:mm instead of h:mm. For example, 1500 minutes divided by 1440 gives 1.0417 days, which with [h]:mm displays as 25:00.

Can I convert minutes to hours without a formula?

Yes. Type 60 in an empty cell, copy it, select your minutes, right-click > Paste Special > Divide. This changes the minutes to decimal hours in place.

What’s the difference between dividing by 60 and dividing by 1440?

Dividing by 60 gives a decimal number of hours (e.g., 2.5). Dividing by 1440 gives a time value (fraction of a day) that you can format as h:mm. Both represent the same duration, just in different formats.

How do I convert a time like 2:30 back to minutes?

Multiply the time by 1440. So =TIME(2,30,0)*1440 returns 150. If the time is in a cell, use =A1*1440 and format as a number.

Related

• Gray Code Calculator: Binary Conversion Tool
• Disc Capacitor Code Calculator & Decoder
• E/M Code Calculator: How It Works

in t | Minutes | min | 150 | 0
out h | Hours (decimal) | h | t / 60 | 2
out hm | Hours and minutes | h:mm | t / 1440 | time