The Excel MINUTE function extracts the minute component of a time as a number between 0-59. For example, with a time of 9:45 AM, minute will return 45. You can use the MINUTE function to extract the minute into a cell, or feed the result into another function like the TIME function.
Syntax: =MINUTE (serial_number)
The Minute function syntax has the following arguments:
Serial_number (required argument) – The time that contains the minute we want to find.
The argument can be entered as:
- A decimal (serial number) representation of an Excel time
- A text representation of a time
- A reference to a cell containing a time
- A time value returned from another Excel function or formula
Example: Let’s look at some Excel MINUTE function examples and explore how to use the MINUTE function as a worksheet function in Microsoft Excel:
Syntax: =MINUTE(A2)
Result:
=MINUTE(A3)
Result: 50
=MINUTE(A4)
Result: 51
=MINUTE(A5)
Result: 41
