What is EXCEL SECOND FUNCTION
The Excel SECOND Function is listed under Microsoft Excel's Time Functions category. It returns the seconds value from a valid time. Time value is made up of, hours, minutes, and seconds and SECOND function takes seconds value and ignores the rest of all.
How to use it
To learn how to use the SECOND function in Excel, you need to understand its syntax and arguments:
- serial_number: A valid time from which you want to get the second value.
- Integer part represents date and decimal part represents time.
To master the SECOND function we need to try it out in an example and below is one which you can try out:
In the below example, we have used different input value to get second. The input value should be a valid date and time as per Excel’s date and time system.
An input value that has no value of seconds in it will return 0 as a result.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.