The Excel MINUTE function returns the minute portion of time as a number between 0-59.
serial_number, required, a valid Excel time, containing a minute you want to find.
- The text within quotation marks (g., “6:45 PM”), the decimal numbers 0.78125, which represents 6:45 PM or the results of other formulas or functions (e.g., TIMEVALUE(“6:45 PM”)) is accepted as a serial_number argument for the MINUTE function.
- TIME values are part of a DATE value; decimal number 0.5 represents TIME 12:00 PM, it’s half of a day.
- Please read “How does Excel Store Dates and Times” for more information on how excel handles DATE and TIME
Seven TIME value in column A. What is the result of the MINUTE function in column B that uses data in column A from the second row to eight row as the serial_number argument.
MINUTE Function #1
Cell A2 contains a text that has HH:MI:SS AM/PM time format. Excel tries to convert every text used in the serial_number argument to a TIME value. For cell A2 Excel successfully converts it, the MINUTE function returns 15.
MINUTE Function #2
Just like cell A2, cell A3 contains a text too but with a different time format, HH24:MI:SS. Whatever the TIME format, excel converts the text to a TIME value. As a result, the MINUTE function returns 20.
MINUTE Function #3
Cell A4 contains a decimal number 0.21244212962963. To find out the TIME value of a decimal number, format the cell containing the decimal number using format cell – time format, whatever the format options will display the TIME value.
As a result, the MINUTE function returns 5.
MINUTE Function #4
The MINUTE function #4 and the MINUTE function #5 return the same number. Cell A5 is the TIME value display for the decimal number in cell A4.
TIME value in cell A5 is not typed manually but a result from a TIMEVALUE function. Other alternatives you can use the TIME function for the same result.
MINUTE Function #5
Not only TIME value, but you can also use the DATE and TIME value in a cell for the MINUTE function serial_number argument.
The result remains to extract the minute numbers and ignore the other components (year, month, day, hour and second).
As a result, the MINUTE function return 23
MINUTE Function #6
Cell A7 contains unusual data, there should be no TIME value with 70th seconds, but the MINUTE function does not return an error, why?
If there are seconds value that exceeds 60, Excel will add the minute value. So the TIME value 23:15:70 is equal to 23:16:10.
Is that why the MINUTE function returns 16 instead of 15.
MINUTE Function #7
Cell A8 contains unusual data like cell A7, but why does the MINUTE function return an error?
As previously explained if there is a second value more than 60 it will add a minute value, the problem is that the minute value has reached its maximum value, as well as the hour value, this is causing the #VALUE! error.
Please see the image below for the complete results of the MINUTE function in column B