SECOND Function

Returns the seconds from a time.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A number from 0 to 59

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

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

ArgumentRequired?What it does
serial_numberYesA 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)
AB
1Logged atSecond
29:30:15 AM15
36:45:59 PM59
412:00:00 AM0
=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

Kyle Stott

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.