Excel Function : SECOND

Download now!

Excel Function : SECOND


Date and time


Converts a serial number to a second

Microsoft Excel Reference Page


Syntax and Description of the SECOND Excel Function

syntax I am trying to use the SECOND function in Excel and can't seem to get the syntax right. =SECOND(A2) Returns: #Value! =SECOND(A2:A3) Returns: #Value! =SECOND(A2,A3) Returns: #Value! =SECOND(A2:A3,) Returns: #Value! =SECOND(A2) Returns: #Value! A: The syntax of Second function is

About SECOND Excel Function

SECOND(serial_number) The SECOND function returns the seconds of a time value. The seconds are given as an integer between 0 and 59.