Excel Function : SECOND

Download now!

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.