ReferenceFunctionsDate & Time Functions
MINUTE
Extracts the minute component (`0` to `59`) from a time or datetime serial.
Summary
Extracts the minute component (0 to 59) from a time or datetime serial.
Remarks
- The integer date portion is ignored for minute extraction.
- Conversion uses Excel 1900 serial interpretation for the date portion when present.
- Time is derived from the fractional serial component.
Examples
Extract minute from 15:30:45
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
30
Extract minute from exact noon
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Related functions
FAQ
Does MINUTE round to nearest minute?
No. MINUTE extracts the minute component from the interpreted time value; it does not independently round to minute precision.
Runtime metadata
Category
Date & Time
Signature
MINUTE(arg1: Number)Arity
min 1, max 1
Arguments
arg1Number · Scalar · coercion NumberLenientText
Caps
PURE
Source