SECOND

Description: Returns the number of seconds (0 to 59) from the specified time value. The time can be entered in a valid text format (in quotes) or as a serial number. For example, =SECOND("8:48:30 AM") and =SECOND(0.3670138889) both return 30.

Syntax: SECOND(Serial_number)

Serial_number is 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")). Note that the Serial_number must be in quotation marks.

Remarks:

Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).

Example:

SECOND("4:48:18 PM") = 18
SECOND("4:48 PM") = 0