MINUTE

Returns the minute component of a time as a whole number, so MINUTE of 09:45:22 gives 45. It pulls one part out of a time value, alongside HOUR and SECOND.

When to use

Give the result cell the General format, not a time format, because it is a plain whole number. Use it when you need to take a time apart rather than build one with TIME.

See Lec 05.

Appears in

No references yet.