Description
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.
=SECOND(serial_number)
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”)).
