The SECOND function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SECOND function can be entered as part of a formula in a cell of a worksheet.
Syntax: =SECOND(serial_number)
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”)).
The argument can be entered as:
- A decimal (serial number) representation of an Excel time
- A text representation of a time
- A reference to a cell containing a time
- A time value returned from another Excel function or formula
Example: Let’s look at some Excel SECOND function examples and explore how to use the SECOND function as a worksheet function in Microsoft Excel:
Syntax: =SECOND(A2)
Result:
=SECOND(A4)
Result: 2
=SECOND(A5)
Result: 26
=SECOND(A5)
Result: 29
