SECOND Function – Examples in Excel, VBA, Google Sheets
Written by
Reviewed by
Download the example workbook
This tutorial demonstrates how to use the SECOND Function in Excel to get the seconds from a time.
SECOND Function Examples
The SECOND Function returns the second number of a time:
=SECOND(B4)
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(10,10,SECOND(B4))
SECOND in Google Sheets
The SECOND Function works exactly the same in Google Sheets as in Excel:
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.