Skip to content
Excel

SECOND function in Excel

Converts a serial number to a second

=SECOND(serial_number)

SECOND syntax and parameters

One argument, one required.

  • serial_numberanyRequired

    The time that contains the seconds you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).

SECOND examples

Formulas you'll actually reuse.

  1. The seconds part of a 09:05:30 timestamp:

    =SECOND(B2)

    Result30

  2. A lap time in whole seconds from start and finish timestamps:

    =SECOND(C2 - B2) + MINUTE(C2 - B2) * 60

SECOND in Google Sheets

Same name — your formula ports as-is.

Try SECOND in the playground

Edit the example — nothing to install.

Preloaded with the SECOND formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.