Excel SECOND() function

Last update on August 19 2022 21:50:55 (UTC/GMT +8 hours)

SECOND() function

This function is used to return the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.

Version: Excel 2013

Syntax:

SECOND(serial_number)

Parameters:

Name	Description	Data Type	Required/ Optional
Serial_number	The time that contains the seconds you want to find. Times may be entered as text strings within quotation marks.	strings	Required

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 - 1:

The example below returns seconds for the time specified in cell B2.

Example - 2:

The example below returns seconds for the time specified in cell B2.

second2

Previous: Excel NOW ()function
Next: Excel TIME() function