SECOND in Google Sheets: Extract Clock Seconds and Check Whole-Second Boundaries

• Introduced: first introduction date is not established by the official history reviewed; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official SECOND reference. Documentation and independent models, with no native Google Sheets execution or wider client certification.

=SECOND(time)

Use a date-time cell, a function returning a date-time value or a suitable numeric serial. Google notes that a DATE-only value has a midnight time portion. The reference describes an integer second output but does not settle every subsecond rounding boundary.

The examples below use numeric TIME and DATE controls. Google’s page includes a quoted-time example, while also warning about automatic conversion; that is not treated as a promise that every imported time string is accepted.

=SECOND(TIME(8,15,0))
=SECOND(TIME(8,15,30))
=SECOND(TIME(8,15,59))
=SECOND(TIME(8,16,0))

Expected results are 0, 30, 59 and 0. The second component resets as the clock moves into the next minute. A result of zero does not mean the time itself is midnight.

The displayed component should remain a plain number. Applying a time format to 30 would reinterpret that integer rather than recover the original 08:15:30 input.

=SECOND(DATE(2026,10,14)+TIME(8,15,30))
=SECOND(DATE(2026,10,15)+TIME(19,45,30))
=SECOND(DATE(2026,10,14))

Expected results are 30, 30 and 0. The first two full timestamps differ in date, hour and minute, yet share the same second component. The date-only value supplies midnight, whose second component is zero.

Keep the full values when comparing event times. A second component alone cannot identify which minute, hour or day an event occurred in.

For the four whole-second times in the first example, use:

=SECOND(A2)=0

Expected flags are TRUE, FALSE, FALSE and TRUE. This answers whether the second component is zero within the stated whole-second fixture.

It is not a general subsecond precision test. A value carrying a fractional second needs an independently verified rule before this expression can establish that it lies exactly on a minute boundary.

For whole-second values:

=AND(MOD(MINUTE(A2),15)=0,SECOND(A2)=0)

Expected flags for 08:15:00, 08:15:30, 08:30:00 and 08:31:00 are TRUE, FALSE, TRUE and FALSE. The second test rejects a timestamp halfway through the minute even though its minute number is divisible by fifteen.

This is an explicit alignment policy. It does not round an off-boundary timestamp or prove that an event was recorded accurately.

For A2 containing =TIME(8,15,30):

=3600*HOUR(A2)+60*MINUTE(A2)+SECOND(A2)

Expected result: 29730 seconds since midnight. The individual terms contribute 28800, 900 and 30. SECOND alone supplies only the final 30.

For the separate control =TIME(1,2,3), the same construction gives 3723, while SECOND gives 3. Multiplying the original time fraction by 86400 produces the same ordinary whole-second total.

Put =DATE(2026,10,14) in D2 and =DATE(2026,10,15)+TIME(1,1,1) in E2:

=86400*(E2-D2)
=SECOND(E2)-SECOND(D2)

Expected results are 90061 and 1. The full interval contains one day, one hour, one minute and one second: 86400+3600+60+1.

Neither a subtraction of second components nor reconstruction of the end clock alone retains the completed day. Use the whole timestamp difference when the question concerns elapsed duration.

Google’s TIMEVALUE reference explicitly allows fractional-second text such as 11:59:59.50 PM. That proves the time fraction can contain subsecond information; it does not, by itself, define how SECOND rounds or truncates it.

No exact-half, near-minute carry or floating-point tolerance behavior was executed here. Negative serials, malformed text, blank coercion and a full error-code matrix also remain unverified. Do not import another spreadsheet’s SECOND rounding rule merely because the name matches.

A bare colon expression such as SECOND(12:00:00) is not a valid literal-time input. Prefer TIME for numeric components and TIMEVALUE for recognized time text. Related components are HOUR and MINUTE.

• Google SECOND reference.
• Editorial testing standards.

Examples use fictional inputs, English function names and comma argument separators. Expected outputs are independently modeled from the cited rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.