How to use Excel SECOND Function


SECOND function in Excel is a type of DATE/TIME function. This function is used to find seconds from a given time. It gives result in form of numbers ranging from 0 to 59. For example, for time 10:15:33 AM, SECOND function will retrieve 33 as the result. SECOND can also be used with the TIME function for feeding seconds into this function.




  • Serial_Number- This is time in a valid excel format or a cell number containing the valid time.


  • Time values are represented in form of decimal numbers, for example 6:00 PM is represented by 0.75 as it is 0.75 of 24 hours which is 18 hours.
  • Time can be entered in form of text strings or decimal numbers; to reduce errors, TIME function can be used to supply time.
  • Excel default format for storing date and time is in form of serial numbers; to view it in readable form, use formatting tab.
  • It can be used as a feeder to insert seconds in TIME function.


In this example, Time is given in column A and SECOND is used in column B to extract number of seconds from the time.

Leave a Comment

Your email address will not be published. Required fields are marked *