Skip to main content

SECOND

The SECOND function returns the seconds (0-59) component of a time value.

Syntax​

=SECOND(serial_number)

Parameters​

  • serial_number: The time value from which to extract the seconds

Examples​

=SECOND("13:45:30") // Returns 30
=SECOND("9:15:45 AM") // Returns 45
=SECOND(NOW()) // Returns the current second