MINUTE

The MINUTE function returns the minutes (0-59) component of a time value.

Syntax

=MINUTE(serial_number)

Parameters

• serial_number: The time value from which to extract the minutes

Examples

=MINUTE("13:45:30") // Returns 45
=MINUTE("9:15 AM") // Returns 15
=MINUTE(NOW()) // Returns the current minute