SECOND (Value)
- where is the time or serial number of time to find the seconds value.
SECOND(), converts a serial number to a second.
Description
SECOND(Value)
For Example,
SECOND("3:45:20 AM") returns 20
- 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:00 AM".
- If is invalid, Calci returns an #ERROR message.
- The output seconds value is the value in integers, ranging from '0' to '59'.
Examples
Function | Output |
SECOND("12:00:00 AM") | 0 |
SECOND("5:59 PM") | 0 |
SECOND("2:30:44") | 44 |
SECOND("10:33:59 PM") | 59 |
Related Videos
See Also
References