MINUTE

See also A-Z Spreadsheet Function List

Description Returns the minute that corresponds to the supplied date.

Syntax MINUTE(serial_number)

serial_number is the time as a serial number. The decimal portion of the number represents time as a fraction of the day.

Remarks The result is an integer ranging from 0 to 59.

See Also DAY , HOUR , MONTH , NOW , SECOND , WEEKDAY , and YEAR functions

Examples MINUTE(34506.4) returns 36

         MINUTE(34399.825) returns 48