How can I use the SECOND function in Google Sheets?

Returns the second component of a specific time, in numeric format.

Sample Usage

SECOND(TIME(11,40,59))

SECOND(A2)

SECOND(40909.0004)

SECOND("20:49:59")

Syntax

SECOND(time)

• time – The time from which to calculate the second component. Must be a reference to a cell containing a date/time, a function returning a date/time type, or a number.

Notes

• Ensure that the input to the function is either a reference to a cell containing a date/time, a function which returns a date/time object such as TIME, or a date serial number of the type returned by the N function. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.

• SECOND does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, SECOND(12:00:00) will return an error.

• SECOND returns the intuitive understanding of seconds, and is useful primarily in other calculations rather than to extract the second component of a known time, as that value is easily known from a plain reading of the entire time.

• Note that date objects that are created with the DATE function or by entry of a date without a time component will have a time of 0:00:00.

See Also

YEAR: Returns the year specified by a given date.

WEEKDAY: Returns a number representing the day of the week of the date provided.

TO_DATE: Converts a provided number to a date.

TIME: Converts an hour, minute, and second into a time.

SECOND: Returns the second component of a specific time, in numeric format.

N: Returns the argument provided as a number.

MONTH: Returns the month of the year a specific date falls in, in numeric format.

MINUTE: Returns the minute component of a specific time, in numeric format.

HOUR: Returns the hour component of a specific time, in numeric format.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a year, month, and day into a date.

Examples

Returns the second as an integer for the given time value.

[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdDJNOE9fS3VjdVhPX1NQdmdqc0ZiWkE&single=true&gid=0&output=html&widget=true” width=”500″]