Excel like a finance pro.
← The libraryPractice · 2 questions →
Date function
SECOND
Returns the second from a time.
Rarely usedDifficulty 950 · CapableUsage rank #237 of 520
When to use it
The second, 0 to 59, from a time.
The shape of it
- Syntax
=SECOND(serial_number)
Worked examples
Second of a time
=SECOND(TIME(18,45,30)) → 30
Thirty seconds.
Now
=SECOND(NOW()) → 17
Seconds on the clock at recalculation.
Seconds since midnight
=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1) → 67530
Seconds since midnight for 6:45:30 PM.
Worth knowing
- Durations in seconds: multiply the difference by 86400.
- Milliseconds are kept in the serial but SECOND rounds them away.
- Works on date-times.
Where it goes wrong
- Returns only the seconds component.
- Text input returns #VALUE!.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.