SECOND
Gets the second component of the specified date.
Syntax
=SECOND(date)
Arguments
| Argument | Type | Description |
|---|---|---|
| date | Date | The 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
Updated 9 months ago