ReferenceFunctionsDate & Time Functions
SECOND
Extracts the second component (`0` to `59`) from a time or datetime serial.
Summary
Extracts the second component (0 to 59) from a time or datetime serial.
Remarks
- The integer date portion is ignored for second extraction.
- Conversion uses Excel 1900 serial interpretation when resolving datetime values.
- Time is computed from the serial fraction and rounded to whole seconds.
Examples
Extract second from 15:30:45
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
45
Extract second from exact noon
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Related functions
FAQ
Can SECOND return 60 for leap seconds?
No. SECOND returns values from 0 to 59 based on spreadsheet serial-time interpretation.
Runtime metadata
Category
Date & Time
Signature
SECOND(arg1: Number)Arity
min 1, max 1
Arguments
arg1Number · Scalar · coercion NumberLenientText
Caps
PURE
Source