How to use the Excel SECOND function

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:

  1. A decimal (serial number) representation of an Excel time
  2. A text representation of a time
  3. A reference to a cell containing a time
  4. 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:

Excel SECOND - How to use the Excel SECOND function

Syntax: =SECOND(A2) 

Result:

Excel SECOND Function - How to use the Excel SECOND function

=SECOND(A4)
Result: 2

=SECOND(A5)
Result: 26

=SECOND(A5)
Result: 29

Add a Comment

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