Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

SECOND

Returns the seconds component from a time value in Excel
Converts a serial number to a second.

Rational

Returns the seconds component from a time value.

Description

The Excel SECOND function returns the second component (a number from 0 to 59) of the corresponding time. For example, with a time of 6:48:15 PM or text (e.g. “6:48:15 PM”), the SECOND function will return ‘15’.

Syntax

=SECOND (serial_number)

Parameters

serial_number – A valid argument of time, string representation or a serial number of a specific time recognized by Excel.

Return Value

An Integer between 0 and 59 (specific seconds in an hour).

Key Notes

  • Time value in the function may be entered in time, text and serial number format in the specific cell of the worksheet.
  • Time is stored as a serial number in Excel, a number from 0 (12:00:00 AM) to 0.999988426 (11.59:59 PM).
  • Like SECOND(0.6565) = 24*.65 = 15.756, return as .756*60 (minutes) = 45.36 and further calculate seconds we further drill down 0.36*60 (seconds) =21.6. The return value in Excel would be 22.
  • Use MINUTE and HOUR functions to return other two components of Timestamp.

Keep Reading Similar Functions:

Returns current date and time in Excel.

NOW

The NOW function returns the serial number of the current date and time. Example; to show the current date and time, use NOW(), empty parenthesis.

Read More »
Return date by combining Hour, Minute and Seconds in Excel

TIME

The TIME function returns the time value by merging the three-time components. Example, use =TIME(9,15,35), that may returns “09:15:35”.

Read More »
Find hour component from a time value in Excel

HOUR

The Excel HOUR function returns the hour component of a timestamp between 0 (12:00 A.M.) and 23 (11:59 P.M.), use =HOUR(0.3) that returns ‘7’ (0.3*24).

Read More »
Return only the day value of a date in Excel

DAY

The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.

Read More »
Find minute component from a timevalue in Excel

MINUTE

The MINUTE function returns the minute component of a time value. For example, with a time of 6:48 PM or text, =MINUTE(time) will return ’48’.

Read More »