Navigation:  Formulas and functions > Functions from A to Z > MINUTE (minute)

Syntax:

MINUTE(Time)

Description:

This returns the minutes of a time value.

Example:

MINUTE("12:34:56 AM") returns 34

MINUTE("09/25/2018 10:30:56 AM") returns 30

If cell A1 contains a date with the time 10:30:56 then MINUTE(A1) returns 30

See also:

HOUR, SECOND, MILLISECONDS