MINUTE
Converts a serial number to a minute.
Date & TimeDates & Time Calculations
What it does
Returns the minute component (0-59) of a time.
Syntax
MINUTE(serial_number)
Arguments
serial_number(time) — Time value.
Examples
Get Minute
Extract minute from 10:45.
FORMULA
=MINUTE("10:45")RESULT
45
SAMPLE DATA
| A | |
|---|---|
| 1 | Time |
| 2 | 10:45 |