SECOND Function - Excel
Overview
The SECOND function in Excel is a useful tool for extracting the second component from a time. This function returns the value of a number between 0 and 59.
Example:
=SECOND("3:30:35 PM")
Syntax:
=SECOND(serial_number)
serial_number: This is the time from which you want to extract the second.
Example
In this example, the SECOND function returns a value of 35 because the time it is extracting it from is “3:30:35 PM”.
