Returns the minute component, as an integer, for the given time value.
Sample Usage
MINUTE("14:25:30")
MINUTE(C5)
Syntax
MINUTE(time)
- time - The time from which to calculate the minute.
Examples
MINUTE("14:25:30") returns the minute component, which is 25.
MINUTE(C5) returns the minute component of the time value contained in C5.
Notes
- Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object, or a date serial number.
- MINUTE does not auto-convert number formats. Therefore, MINUTE(12:00:00) will return an error.