Excel Get Minutes from Time: Formula Guide
- Time (HH:MM)
- 1.5
- You entered
To get minutes from a time value in Excel, multiply the time by 1440 (the number of minutes in a day) and format the result as a number. For example, if cell A1 contains 1:30, the formula =A1*1440 returns 90. This works because Excel stores times as fractions of a 24-hour day, so 1:30 PM is stored as 0.5625, and 0.5625 × 1440 = 810 minutes since midnight.
Formula
The core formula is:
Minutes = Time × 1440
Where:
- Time – the Excel time value (a decimal fraction of a day). For example, 6:00 AM is 0.25, 12:00 noon is 0.5, and 6:00 PM is 0.75.
- 1440 – the number of minutes in a day (24 hours × 60 minutes).
If you want only the minutes component (ignoring hours), use =MINUTE(A1). That returns an integer from 0 to 59. If you want the total minutes including hours, use =A1*1440.
Worked Example
Using the default value from the calculator above, let’s convert 1.5 hours (1 hour 30 minutes) to total minutes.
- Enter 1:30 in cell A1. Excel stores it as 0.0625 (because 1.5 hours ÷ 24 = 0.0625).
- In cell B1, enter
=A1*1440. - Excel calculates 0.0625 × 1440 = 90.
- Format cell B1 as a number (not time) to see 90.
So 1 hour 30 minutes equals 90 minutes. If you had entered 1.5 as a plain number (not a time), the same formula would give 2160 – which is wrong because 1.5 is not a time value. Always ensure the source cell is formatted as time.
How Excel Stores Time
Excel treats a time as a fraction of a 24-hour day. This is why you can multiply by 1440 to get minutes. For example:
- 0:15 (15 minutes) → 0.0104167 → ×1440 = 15
- 2:45 (2 hours 45 minutes) → 0.1145833 → ×1440 = 165
- 23:59 → 0.9993056 → ×1440 = 1439
This system also lets you add and subtract times easily. If you subtract a start time from an end time, you get a decimal fraction that you can convert to minutes the same way.
Common Mistakes and Fixes
The most frequent error is forgetting to format the result as a number. If you leave the cell formatted as time, you’ll see something like 1:30 instead of 90. To fix it: select the cell, go to the Home tab, and change the number format to “Number” or “General”.
Another mistake is using =MINUTE() when you actually need total minutes. =MINUTE(A1) returns only the minute part (0–59), so for 1:30 it returns 30, not 90. If you need the full duration in minutes, use the multiplication method.
Also watch out for times that cross midnight. If you subtract 10:00 PM from 2:00 AM, Excel gives a negative value. Use the MOD function: =MOD(B1-A1,1)*1440 to get the correct positive minutes.
Alternatives: MINUTE, HOUR, and TEXT Functions
Depending on what you need, there are other functions:
=MINUTE(A1)– returns the minute component (0–59).=HOUR(A1)– returns the hour component (0–23).=HOUR(A1)*60 + MINUTE(A1)– gives total minutes (same as ×1440).=TEXT(A1,"mm")– returns the minutes as text (e.g., “30”). This can be useful for concatenation but is not a numeric value.
If your time is stored as text (e.g., “1:30” as a string), you can convert it first with =TIMEVALUE(A1) and then multiply by 1440.
When to Use Each Method
Use =A1*1440 when you need the total number of minutes in a duration (e.g., to calculate pay or billing). Use =MINUTE(A1) when you need only the minute part of a clock time (e.g., to extract the minute from a timestamp). Use the MOD formula when subtracting times that span midnight.
For example, if you track work hours and want to know how many minutes an employee worked between 9:15 AM and 5:45 PM, you would subtract: =(B1-A1)*1440 gives 510 minutes (8.5 hours). But if you just want to know what minute of the hour a timestamp falls in, =MINUTE(A1) is correct.
Frequently Asked Questions
Why does my formula return a time instead of a number?
Because the cell is still formatted as time. Change the number format to General or Number. Right-click the cell, choose Format Cells, and select Number. The underlying value is correct; only the display is wrong.
How do I convert “1:30 PM” to minutes?
The same formula works. If A1 contains 1:30 PM, =A1*1440 returns 810 (since 1:30 PM is 13.5 hours after midnight). If you want the minutes since the start of the day, that’s correct. If you want the minutes in the 12-hour period, subtract 720 (12 hours) from the result.
What if my time is over 24 hours, like 25:30?
Excel can display times over 24 hours if you format the cell as [h]:mm. The underlying value will be 1.0625 (25.5 hours ÷ 24). Multiplying by 1440 gives 1530 minutes, which is correct.
Can I use this to convert minutes back to time?
Yes. Divide minutes by 1440 and format as time. For example, =90/1440 formatted as h:mm shows 1:30.
Does this work in Google Sheets too?
Yes, Google Sheets uses the same time storage system and the same formula. The only difference is the formatting menu, but the math is identical.
Related
Formula used
in t | Time (HH:MM) | - | 1.5 | 0 out minutes | Total minutes | min | t * 1440 | 0
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.