MINUTE

Definition: MINUTE is a function that returns the minute component of a given time value.

Syntax: =MINUTE(serial_number)

Situation: This formula is appropriate when you need to find the minute component of a given time value.

Example: If you have a time value 3:45 PM, the minute component can be found using the formula =MINUTE(“3:45 PM”), which returns 45.