MINUTE function
The MINUTE function is used to extract minutes from a time value in Excel. It returns a number from 0 to 59, corresponding to the minute component of the passed time.
This is convenient when analyzing timestamps, logs, events, and any situations when you need to work with time components separately.
MINUTE function syntax
=MINUTE(time)- time — time value or reference to a cell containing time.
MINUTE formula examples
=MINUTE(A1)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Value | HOUR | MINUTE | SECOND |
| 2 | 12:45:27 | 12=HOUR(A2) | 45=MINUTE(A2) | 27=SECOND(A2) |
| 3 | 14:32:45 | 14=HOUR(A3) | 32=MINUTE(A3) | 45=SECOND(A3) |
| 4 | 10/22/2026 08:15:00 | 8=HOUR(A4) | 15=MINUTE(A4) | 0=SECOND(A4) |
| 5 | 0.5 (number) | 12=HOUR(A5) | 0=MINUTE(A5) | 0=SECOND(A5) |
| 6 | 2:30 PM | 14=HOUR(A6) | 30=MINUTE(A6) | 0=SECOND(A6) |
| 7 | 25:10:05 (duration) | 1=HOUR(A7) | 10=MINUTE(A7) | 5=SECOND(A7) |
Each function takes its own part of the time. The date part is ignored, and a duration over 24 hours loses its whole days: 25:10:05 gives HOUR 1. MINUTE is always between 0 and 59.
If cell A1 contains the time 14:32:45, the result will be 32.
=MINUTE(NOW())Extracts the number of minutes from the computer's current time.
=MINUTE(TIME(8, 15, 0))| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | =MINUTE(TIME(8,15,0)) | 15=MINUTE(TIME(8,15,0)) |
| 3 | =MINUTE(TIME(0,90,0)) | 30=MINUTE(TIME(0,90,0)) |
| 4 | =TIME(0,90,0)*1440 | 90=TIME(0,90,0)*1440 |
| 5 | =MINUTE("2:45 PM") | 45=MINUTE("2:45 PM") |
| 6 | =ROUND("2:45"*1440,0) | 165=ROUND("2:45"*1440,0) |
TIME builds a time from parts; the extraction functions take them back. To get the total, not the part, multiply: minutes = A*1440, seconds = A*86400.
Result — 15, since that's how many minutes are specified in the TIME function.
Other Date and Time functions in Excel
TIMEVALUE, TIME, YEAR, DATE, DATEVALUE, EDATE, DAY, WEEKDAY, YEARFRAC, EOMONTH, MONTH, WEEKNUM and ISOWEEKNUM, WORKDAY, DATEDIF, TODAY, SECOND, NOW, NETWORKDAYS
Like the article? Help its author! Buy !SEMTools, it has lots of useful instruments to process text data.