Extract Minutes from Time in Excel
To extract minutes from a time value in Excel, use the MINUTE function, which returns the minute component (0–59) as an integer. For example, =MINUTE(A1) converts the time in cell A1 (like 3:45 PM) into the number 45. If you need total elapsed minutes (e.g., 3 hours and 45 minutes = 225 minutes), multiply the time by 1440 (the number of minutes in a day) and format the result as a number.
How Excel Stores Time
Excel stores dates and times as decimal numbers. A full day equals 1.0, so 6:00 AM is 0.25, 12:00 PM is 0.5, and 6:00 PM is 0.75. The time 3:45 PM is stored as 0.65625 (because 15.75 hours ÷ 24 = 0.65625). This underlying decimal is what makes time arithmetic possible, but it also causes confusion when you try to extract minutes directly with simple multiplication.
The MINUTE function ignores the hour and second components entirely. It works on any time value, whether entered directly (e.g., =MINUTE("10:23") returns 23) or referenced from a cell. It also works on dates with times; the date part is ignored.
Using the MINUTE Function
The syntax is simple: =MINUTE(serial_number) where serial_number is a time value, a cell reference, or a text string that Excel can parse as a time.
=MINUTE(A2)– returns the minute of the time in A2.=MINUTE("9:07 PM")– returns 7 (text is converted automatically).=MINUTE(NOW())– returns the current minute (updates when the sheet recalculates).
If the cell contains a time with seconds, the seconds are ignored. For example, =MINUTE("10:23:45") returns 23, not 23.75. If you need seconds as a decimal, use =MINUTE(A1) + SECOND(A1)/60.
Extracting Total Minutes (Elapsed Time)
When you want the total number of minutes in a duration (e.g., a shift of 8 hours and 30 minutes = 510 minutes), the MINUTE function only gives the 30. Instead, multiply the time value by 1440 (24 hours × 60 minutes).
=A1*1440
Format the result cell as a number (not as time). If you leave it as time, you will see a nonsense value like 8:30 displayed as a time-of-day. For example, if A1 contains 8:30 AM (stored as 0.35417), multiplying by 1440 gives 510, which is the correct total minutes.
Be careful with durations that exceed 24 hours. If you enter a duration as 1:30 (meaning 1 hour 30 minutes), Excel treats it as 1:30 AM, which is 90 minutes after midnight. Multiplying by 1440 gives 90, which is correct. But if you enter 25:00 as a duration, Excel may interpret it as text unless you format the cell as [h]:mm first. In that case, the underlying value is 1.04167 (25/24), and multiplying by 1440 gives 1500 minutes, which is correct.
Common Mistakes and How to Avoid Them
- Using MINUTE for elapsed time: MINUTE only returns the minute component, not the total. Use
*1440for total minutes. - Formatting the result as time: After multiplying by 1440, the result is a number. If you format it as time, you will see a fraction of a day (e.g., 510 minutes shows as 8:30 AM). Change the number format to General or Number.
- Text times that look like times: If a cell contains text like “10:23” (with an apostrophe before it), MINUTE will return #VALUE!. Use
=MINUTE(TIMEVALUE(A1))to convert text to a real time first. - Negative times: If you subtract a later time from an earlier one, Excel may show ##### or a negative decimal. Use the MOD function to wrap around midnight:
=MOD(B1-A1,1)*1440.
Extracting Minutes from a Date-Time Value
When a cell contains both a date and a time (e.g., 2025-03-15 14:45), the MINUTE function still works because it only looks at the fractional part. The date is the integer part, and the time is the decimal fraction. So =MINUTE(A1) returns 45 regardless of the date.
If you need to separate the time from the date first, use =MOD(A1,1) to get the time fraction, then apply MINUTE. This is useful when you want to sum times across multiple dates without accidentally including the date.
Alternatives: HOUR, SECOND, and TEXT
For other components, use HOUR and SECOND functions, which work identically to MINUTE. For a text representation of the minute with leading zeros (e.g., “05”), use =TEXT(A1,"mm") – this returns a text string, not a number. If you need the minute as a number but with leading zeros for display, use =TEXT(A1,"mm")*1 or just format the cell as 00.
For extracting minutes from a duration that is stored as a decimal number of hours (e.g., 2.5 hours), multiply by 60 to get total minutes, then use =MOD(A1*60,60) to get the minute component. For example, 2.5 hours → 150 minutes → MOD(150,60) = 30 minutes.
Frequently Asked Questions
Why does my MINUTE formula return 0 for times like 12:30?
If the cell is formatted as text or contains a leading apostrophe, Excel cannot parse it as a time. Check the cell format (Home → Number Format) and ensure it is set to Time. If it is text, use =MINUTE(TIMEVALUE(A1)).
How do I extract minutes from a time that includes seconds and get a decimal?
Use =MINUTE(A1) + SECOND(A1)/60. This returns the minute as a decimal, e.g., 10:23:45 gives 23.75.
What is the difference between MINUTE(A1) and A1*1440?
MINUTE returns the minute component (0–59) of a time-of-day. A1*1440 returns the total number of minutes that have elapsed since midnight (or since the date part, if any). For 1:30 PM, MINUTE gives 30, while A1*1440 gives 810 (13.5 hours × 60).
Can I extract minutes from a duration that exceeds 24 hours?
Yes, but the cell must be formatted as [h]:mm to display durations over 24 hours. The underlying value is still a fraction of a day, so A1*1440 gives the total minutes. MINUTE will still return the minute component (0–59) of that duration.
Why does my formula return a fraction like 0.75 instead of 45?
That happens when you multiply a time by 60 instead of 1440. For example, 0.75 (which is 45 minutes as a fraction of an hour) is the result of =A1*60 when A1 is 0.0125 (18 minutes). Use 1440 to get minutes in a day.