SECOND
Converts a serial number to a second.
Date & TimeDates & Time Calculations
What it does
Returns the seconds component (0-59) of a time.
Syntax
SECOND(serial_number)
Arguments
serial_number(time) — Time value.
Examples
Get Seconds
Extract seconds from 10:00:45.
FORMULA
=SECOND("10:00:45")RESULT
45
SAMPLE DATA
| A | |
|---|---|
| 1 | Time |
| 2 | 10:00:45 |