How to use Excel SECOND Function

    how to use excel second function

    Quick Intro

    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.

    Syntax

    SECOND(serial_number)

    • 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.

    Examples

    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.

    Examples For Excel SECOND Function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    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.

    There are also you have HOUR | MINUTE functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.