Excel FunctionsExcel SECOND Function

Extract second from Excel


Used to extract seconds as a number from a given Time as a text in Excel. For various working in Excel modeling, we may need to extract seconds from a given time as a text string. In all such cases, the SECOND function comes very handy. It works in a similar manner as HOUR and MINUTE function work. 


The SECOND function syntax has the following argument:

  • Serial_Number Required.

The time that contains the seconds you want to find. 

Times may be entered as text strings within quotation marks (for example, “6:45 PM”), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE(“6:45 PM”)).

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.