SECOND Function – Examples in Excel, VBA, Google Sheets

This tutorial demonstrates how to use the Excel SECOND Function in Excel to get the seconds from a time.

Second Main function

SECOND Function Overview:

The SECOND Function Returns the second as a number (0-59)

To use the SECOND Excel Worksheet Function, Select cell and Type:

second formula syntax

(Notice how the formula input appear)

SECOND Function syntax and Inputs:

serial_number – The time, represented as a fraction of the day or entered as time surrounded by quotations (“s”). Example: You can not enter 8:00:00 pm directly into the cell. Instead you would need to use the corresponding fraction of the day: .3333 or the time surrounded by quorations: “8:00:00 pm”. Alternatively, you can reference a cell with the time entered. Excel automatically converts times stored in cells into a fractional number (unless the time is stored as text).

AutoMacro - VBA Code Generator

SECOND Examples

The SECOND Function returns the second number of a time:

SECOND

SECOND and TIME Functions

Using the TIME and SECOND Functions you can create a new time with the second number from the original time:

Time SECOND

SECOND in Google Sheets

The SECOND Function works exactly the same in Google Sheets as in Excel:

Second Google sheet

SECOND Examples in VBA

You can also use the SECOND function in VBA. Type:
application.worksheetfunction.second(serial_number)
For the function arguments (serial_number, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!