SECOND function

SECOND(date) SECOND(date)

date — Number or { Number }

The date to be converted, as a sequential serial number.

Returns — Number or { Number }

The second of the date (0 through 59).

Converts a date to a number representing the second of the date.

Example

SECOND(TIME(1, 25, 2))SECOND(TIME(1; 25; 2))

Returns 2, the second of the time 1:25:02 (2:25 PM).