Cellgrids Cellgrids
Home › Excel formulas › Date and Time › SECOND

SECOND Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SECOND is an Excel Date & Time function. Pulls just the second out of a time value.

SECOND syntax

=SECOND(serial_number)

Arguments

When to use SECOND

SECOND is used in scheduling, deadline tracking, and reporting that spans specific date ranges.

Practice SECOND online, free

Open the live Excel-style spreadsheet and try SECOND yourself. No Excel install or sign-up needed to start.

Practice SECOND now →

More Date & Time functions

Frequently asked questions

What does the SECOND function do in Excel?

Pulls just the second out of a time value.

What is the syntax of SECOND in Excel?

The syntax is =SECOND(serial_number). serial_number: The date or time value to evaluate.

Where can I practice SECOND online for free?

Open the free live spreadsheet on Cellgrids and try SECOND yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts