These docs are for v1.0. Click to read the latest docs for v1.2.

SECOND

Gets the second component of the specified date.

Syntax

=SECOND(date)

Arguments

ArgumentTypeDescription
dateDateThe date to use for calculation

Examples

=SECOND(DATE(2020, 2, 3, 4, 5))0
Gets the second component 0 from the specified date Feb 3, 2020 4:05:00 AM

=SECOND(DATE(2020, 4, 5, 6, 7, 8))8
Gets the second component 8 from the specified date Apr 5, 2020 6:07:08 AM