SECOND

Returns the seconds component of a time value as a number.

Syntax:

SECOND( time )

Example:

SECOND(23:59:58)

returns the number 58.