Returns the minute corresponding to serial_number. The minute is given as an integer, ranging from 0 to 59.
Syntax
MINUTE(serial_number)
Serial_number is the date-time code used by Microsoft Excel for date and time calculations. You can give serial_number as text, such as "16:48:00" or "4:48:00 PM", instead of as a number. The text is automatically converted to a serial number. For more information about serial_number, see NOW.
Remarks
Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.
Examples
MINUTE("4:48:00 PM") equals 48
MINUTE(0.01) equals 14
MINUTE(4.02) equals 28