Excel Function : SECOND
Category
Date and time
Description
Converts a serial number to a second
Microsoft Excel Reference Page
https://support.office.com/en-us/article/SECOND-function-740d1cfc-553c-4099-b668-80eaa24e8af1
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.