The MINUTE Function returns the minutes of a given time in Excel.
Syntax
MINUTE(serial_number)
Arguments
| serial_number | The time from which you want to extract the minute. |
How to use
The MINUTE function is used to extract the minute from a given time value. Here’s how you can use it:
Example 1: Extracting the minute from a specific time.
|
1 |
=MINUTE("12:45:30") |
This formula will return 45, which is the minute portion of the time 12:45:30.
Example 2 (Optional): Using cell references.
|
1 |
=MINUTE(A2) |
If cell A2 contains a time value, this formula will return the minute portion of that time.
Example 3 (Optional): Extracting minutes from a datetime value.
|
1 |
=MINUTE("2023-11-03 14:30:00") |
This formula will return 30, which is the minute part of the datetime value “2023-11-03 14:30:00”.
Example 4 (Optional): Combining MINUTE with other functions.
|
1 |
=TEXT(A2, "hh:mm")&" has "&MINUTE(A2)&" minutes" |
This formula combines the MINUTE function with the TEXT function to format a time value in cell A2 and display it with the minute portion.
Example 5 (Optional): Handling date and time values together.
|
1 |
=MINUTE(DATE(2023, 11, 3) + TIME(14, 30, 0)) |
This formula creates a datetime value by combining the DATE and TIME functions and then extracts the minute part (30 minutes).
Remember that the MINUTE function only works with valid time values, and it will return an error if the input is not a recognized time format.