March 1, 2024

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) 


Excel SECOND Function - How to use the Excel SECOND function

Result: 2

Result: 26

Result: 29

READ:  How to use the Excel ASC function

Leave a Reply

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