SECOND Function
Returns the seconds from a time.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A number from 0 to 59
Overview
SECOND returns the seconds part of a time, from 0 to 59.
Use it with lap times, call durations or machine logs that record seconds.
Syntax
=SECOND(serial_number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | A time, a date with a time, or time text. |
Examples
Example 1 — Seconds from a log
Each entry records the time to the second.
B2fx=SECOND(A2)
| A | B | |
|---|---|---|
| 1 | Logged at | Second |
| 2 | 9:30:15 AM | 15 |
| 3 | 6:45:59 PM | 59 |
| 4 | 12:00:00 AM | 0 |
=SECOND(A2) Explain
Example 2 — A duration in total seconds
There are 86,400 seconds in a day.
=ROUND((B2-A2)*86400, 0) Explain
Common mistakes
- SECOND returns 0 for every row. The times were entered without seconds, so there are none to return.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.