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.

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’.

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’.

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).

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”.

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.