Functions
MINUTE
Minute component of a time serial number
Try it
When to use it
When should I use MINUTE?
Use MINUTE to extract the minute component (0–59) from a time serial number or time string, useful when computing elapsed time or grouping events into hourly bins.
Used in
Syntax
MINUTE(time)Examples
=MINUTE(TIME(11,40,59)) // => 40
=MINUTE(40909.0004) // => 0
=MINUTE("20:49:59") // => 49