Buzz
This article introduces you to the MINUTE function - one of the functions in the date and time group that is widely used in Excel.
Description: Returns the minute of a time value. The minute is returned as an integer, ranging from 0 to 59.
Syntax: MINUTE(serial_number)
Where: serial_number represents the time value for which you want to calculate the minute. The time value can be entered as a string, a decimal number, or a combination of both forms.
Note:
- The time value is a part of the date value and is represented by a decimal number.
Example:
Calculate the minute value in the following time formats:
- In the cell where you want to calculate, enter the formula: =MINUTE(F7).
- Press Enter -> the minute value in that time value is:
- Similarly, copy the formula for the remaining values to get the result:
- In case the time value is invalid -> the function returns an error value #VALUE!
Here is the guide and some specific examples in working with the MINUTE function.
Wishing you all success!
