SECOND Function

Summary

The Excel SECOND function returns the second component of a time value as a whole number from 0 to 59.

SECOND is useful when you need to break a timestamp into parts, analyze precise log times, build second-based checks, or identify exact boundaries within a minute.

SECOND matters in models that care about fine timing detail. It is not needed for every workbook, but it becomes useful in logs, process timing, or imported timestamps where the last piece of time precision still needs to be checked or displayed separately.

Syntax

=SECOND(serial_number)

The argument is called serial_number because Excel stores times as decimal portions of a date value. In practice, you can pass a time, a date-time, a cell reference, or the result of another formula.

Arguments

• serial_number - A valid Excel time or date-time value that contains the second you want to extract.

SECOND vs Related Time Functions

SECOND works alongside the other time-part extraction functions.

Use SECOND when you need a numeric result for logic or analysis. Use TEXT when you only need a formatted display value.

Using SECOND

Microsoft documents that SECOND accepts times entered as text strings, decimal numbers, or formula results. That means it can work with values from NOW(), imported time strings, or date-time cells that Excel recognizes correctly.

Like other time functions, SECOND works on the underlying serial value, not just the way the cell looks on screen. So it can extract seconds from a full date-time value as long as Excel recognizes the input as valid time data.

A common use is building precise checks. For example, you might test whether an event happened exactly on a minute mark, or whether a timestamp lands on every 10-second checkpoint.

Example 1 - Extract the Second from a Time

The simplest use of SECOND is to pull the second number from a time value.

=SECOND("22:45:30")   // Returns 30

This is useful when you need only the second part and do not care about the hour or minute.

Example 2 - Extract the Second from a Stored Timestamp

SECOND is often used on time values already stored in logs or imported records.

=SECOND(B2)

If B2 contains 22:45:30, the result is 30. This makes the function useful for detailed time-based analysis.

Example 3 - Build a Second-Based Logical Test

You can use SECOND inside a condition to identify specific timing checkpoints.

=MOD(SECOND(B2),10)=0

This returns TRUE when the second lands on a 10-second boundary such as 00, 10, 20, 30, 40, or 50. It is a useful pattern for monitoring and rule-based logic.

Example 4 - Turn the Result into a Label

Combine SECOND with text when you want a display label instead of just a number.

=SECOND(B2)&"s"

This is useful for dashboards, compact summaries, or helper columns where a short text label is easier to read.

Conclusion Recap

SECOND is useful when you need the smallest time part in a normal timestamp breakdown. In this lesson, that meant pulling seconds from stored times, checking exact time boundaries, and turning the result into simple labels for reports.

Like HOUR and MINUTE, this function stays easy to read because it always returns one number. If the formula needs logic based on exact timing, SECOND is the right tool. If you only want the time to look different, formatting is usually enough.

• Summary: SECOND returns the second component of a time value.
• Output: It returns a whole number from 0 to 59.
• Common uses: Precise timestamp analysis, logical tests, and helper columns.
• Input flexibility: It can work with valid time text, decimals, and formula results.
• Display tip: Use TEXT for formatting and SECOND for numeric logic.
• Related functions: Use HOUR and MINUTE to extract other time parts.