Learn Blog Pricing About Sign in

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).