SECOND

Formula Explanation

Returns the seconds from a time value. Seconds are whole numbers ranging from 0 to 59.

Formula Syntax

Enter in the result column: SECOND(column number)

The SECOND function syntax has the following argument:

• Column number (required): A time value containing the seconds you want to retrieve. Time values can be input in various ways:
  • Text strings enclosed in quotes (e.g., "6:45 PM").
  • Decimal numbers (e.g., 0.78125 representing 6:45 PM).
  • Results from other formulas or functions (e.g., TIMEVALUE("6:45 PM")).

Usage Example

Find the seconds of the time in column EG2 and write the result in column EG3.

EG3 = second(EG2)

✉️ Ask Tablize