MINUTE

  • Updated

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.