MINUTE function
MINUTE extracts the minutes from a time value and returns a number from 0 to 59. It is the minute counterpart to HOUR in the same family of time functions.
Example
Read it as a sentence: find the minute part of the value in F1, which gives 0.
Excel shows 0
F
1
Data
Syntax
MINUTE(serial_number)
-
serial_number(required) - A time, date-time, or fraction of a day.
Returns: The minute, 0 to 59.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=MINUTE(TIME(1,30,59)) | 30 | Basic |
=MINUTE("10:45 AM") | 45 | Text |
=MINUTE(0.999999) | 0 | Rounding near midnight |
=MINUTE(Data!F1) | 0 | Blank |
=MINUTE(-0.1) | #NUM! | Negative |
=MINUTE("abc") | #VALUE! | Bad text |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
Data
Watch out for
- Tiny floating-point differences can occasionally make a time like 12:30:00 report 29 minutes.
Where it works
- Excel
- MINUTE is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .