SECOND function
SECOND extracts the seconds from a time value and returns a number from 0 to 59. Fractions of a second are dropped rather than rounded.
Example
Read it as a sentence: make the time 14:45:30, then give its seconds, which gives 30.
A
B
C
D
1
30
2
3
Syntax
SECOND(serial_number)
-
serial_number(required) - A time, date-time, or fraction of a day.
Returns: The second, 0 to 59.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SECOND(TIME(1,30,59)) | 59 | Basic |
=SECOND(0.0000115741) | 1 | About 1 second |
=SECOND("10:30:45") | 45 | Text |
=SECOND(0.5+0.4/86400) | 0 | 0.4 s rounds? |
=SECOND(0.5+0.6/86400) | 1 | 0.6 s rounds? |
=SECOND(-0.1) | #NUM! | Negative |
=SECOND("abc") | #VALUE! | Bad text |
Watch out for
- Fractions of a second are dropped.
Where it works
- Excel
- SECOND is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .