MINUTE(sn)
- where is the time or serial number of time to find the minute value.
MINUTE() returns the minute value from the input time.
Description
MINUTE(sn)
For Example,
MINUTE("4:30 AM") returns 30
- Argument can be time in the form of text or as a result of any other functions.
- Argument should be enclosed in quotes e.g. "11:00 AM".
- If is invalid, Calci returns an #ERROR message.
- The output minute value is the value in integers, ranging from '0' to '59'.
Examples
Function | Output |
MINUTE("12:00:00 AM") | 0 |
MINUTE("5:59 PM") | 59 |
MINUTE("2:30") | 30 |
MINUTE("10:33:59 PM") | 33 |
Related Videos
See Also
References