SECOND
Return the seconds, 0 to 59, from a time value.
Syntax
SECOND(serial_number)| Argument | Required | Description |
|---|---|---|
serial_number | Required | A time, expressed as a fraction of a day. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=SECOND(0.5000116) | 1 | One second past noon. |
=SECOND(0.75) | 0 |
Precision is the thing to watch
One second is roughly 0.0000116 of a day. Any value stored with fewer decimal
places than that has effectively lost its seconds, which is why times imported
from other systems often report 0 here even though the source showed a real
value.
If seconds matter, check what the source actually stored before trusting the result — a rounded time is indistinguishable from a whole-minute one.
Excel compatibility
Matches Excel.