The SECOND function is one of the date and time functions. It returns the second (a number from 0 to 59) of the time value.
Syntax
SECOND(serial_number)
The SECOND function has the following argument:
Argument | Description |
---|
serial_number | The time that contains the second you want to find. |
Notes
The serial_number may be expressed as a string value (e.g. "13:39:15"), a decimal number (e.g. 0.56 corresponds to 13:26:24) , or the result of a formula (e.g. the result of the NOW function - 9/26/12 13:39)
How to apply the SECOND function.
Examples
The figure below displays the result returned by the SECOND function.
