SECOND

Returns the second (0-59) from a time value.

Syntax

SECOND(time)

Arguments

• time: The time from which to extract the second.

Example

SECOND("14:30:45") → Returns 45
SECOND(A1) → Returns the second from the time in cell A1