Functions
SECOND
Second component of a time serial number
Try it
When to use it
When should I use SECOND?
Use SECOND to extract the seconds component (0–59) from a time serial number or time string, useful when you need sub-minute precision from a timestamp.
Used in
Syntax
SECOND(time)Examples
=SECOND(TIME(11,40,59)) // => 59
=SECOND(40909.0004) // => 35
=SECOND("20:49:59") // => 59