SECOND Function

The SECOND() is a date and time function which takes the argument "serial_number" and returns the seconds of a time value as an integer from 0 to 59.

Formula:


=SECOND(serial_number)
In the above syntax, the argument serial_number denotes the time value to extract the second from. It may be expressed as a string value within quotation marks , a decimal number, or the result of a formula.

Video Tutorial:


Let us see how the SECOND function returns the seconds, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question