Date and Time - SECOND Function

Description

The SECOND function returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.

SECOND (serial_number)

Argument	Description	Required/ Optional
Serial_number	The time that contains the seconds, you want to find. Times can be entered as − Text strings within quotation marks (E.g. "6:45 PM") Decimal numbers (E.g. 0.78125, which represents 6:45 PM) Results of other formulas or functions (E.g. TIMEVALUE("6:45 PM"))	Required

Argument

Description

Required/ Optional

Serial_number

The time that contains the seconds, you want to find.

Times can be entered as −

Required

Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).
If the specified serial_number is not a valid Excel time, SECOND returns the #VALUE! Error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_date_time_functions.htm