The Excel MINUTE function returns the minute integer, ranging from 0 to 59, from a time serial number.
Where the serial_number is a date in a format Excel recognises known as the date-time serial number.
Excel MINUTE Function Examples
Tip: 0 is returned in cell C13 because there is no time portion to this date.
The MINUTE function will also accept a text string, no need to convert the text to a date-time serial number first e.g. "4:15 AM"
You can also use the MINUTE Function to populate the minute argument of the TIME function e.g.
Free eBook - Working with Date & Time in Excel
Everything you need to know about Date and Time in Excel, including all Date functions explained with examples - Download the free eBook and Excel file with detailed instructions.
|Excel TIME Function||Returns a time serial number, from separate hour, minute and second values|
|Excel HOUR Function||Returns the hour part of a time serial number|
|Excel SECOND Function||Returns the seconds part of a time serial number|
|Excel DATE Function||Returns a date in serial number from separate year, month and day values|
|Excel Time Calculation Tricks||Time and Date 101, plus common questions answered e.g. convert time to decimals, round time etc.|