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)