Use Excel SECOND Function to extract a number from a time value representing seconds, range from 0 to 59. In simple words, It will return seconds from a time.
For example from 10:45:23 PM it will return 23.
- serial_number A time value with seconds from which you want to extract seconds. You also insert that time value directly into the function using double quotation marks.
More Information on Excel SECOND Function
- Excel stores date as a number. “22-Apr-2016 12:33:10 PM” will represent “42482.5230324074” as a number.
- Integer part represents date and decimal part represent time.
- You can directly insert time value into the function.
In the below example, I have used different input value to get second. Input value should be a valid date & time as per excel’s date & time system. An input value which has no value of seconds in it will return 0 as a result.
To learn more about Excel SECOND Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.