SECOND Function

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.