Read the seconds component from an Apple Numbers date/time value or supported time string. For example, =SECOND(TIME(16,45,30)) is expected to return 30, not the number of seconds elapsed since midnight.

Extract seconds from time-of-day values and build precise timestamp checks in Apple Numbers. For a reproducible time source, use Numbers’ TIME constructor rather than ambiguous local-language time strings. Preserve original imported values when cleaning data so a formula result doesn’t hide a source problem. The examples below intentionally share a dataset with the companion HOUR, MINUTE, SECOND and TIME tutorials while verifying each function’s separate contract.

=SECOND(time)

Return: a numerical time component of the value supplied. The SECOND argument is the date/time value or time string to inspect. It reports the seconds of the time component, rather than creating a duration or converting an entire timestamp to seconds.

Official behaviour: The SECOND reference identifies the date/time-or-string input and illustrates extraction of second 22 from a timestamp. These examples independently apply that operation to TIME-built values. See the official Apple SECOND reference (documentation path 15.4, consulted 2026-10-11). The function-specific help does not establish a first-supported app release; do not extrapolate minimum Mac/iOS/iPadOS/web versions.

Create a Numbers table named Times. Set row 1 as its header. Enter A2:C6 as numbers, not timestrings; set D2:D6 to a Date & Time format that shows clock hours, minutes and seconds, after adding formulas. Columns E–G are formula result columns. No source CSV, external download or screenshot is required.

*The D entries describe the expected clock time. Numbers can show an AM/PM display or include a date depending on the Date & Time cell format. The rows use actual numeric inputs; do not paste the displayed D text to substitute for a time value.

In G2 enter =SECOND(D2) after populating D2 using =TIME(A2,B2,C2). Fill G2:G6.

1. Build the Times table below with column A numeric hours, B numeric minutes and C numeric seconds.
2. Set D2 to =TIME(A2,B2,C2), fill down, and display D as a clock time that includes seconds.
3. Enter =SECOND(D2) in G2 and fill G2:G6.
4. Expected G2:G6: 5, 30, 0, 59, 0.
5. Direct test expected: =SECOND(TIME(9,7,5)) gives 5 and =SECOND(TIME(23,59,59)) gives 59.
6. Apple’s official string example includes a time ending in 11:59:22pm; it expects 22. For reproducible new input, use TIME instead of copying a locale-sensitive date string.

Audit whether records have a nonzero seconds component

If your scheduling system expects records aligned to the nearest minute, put this formula in H2 and fill through H6:

=IF(SECOND(D2)=0,"On exact minute","Seconds present")

Expected H2:H6: Seconds present, Seconds present, On exact minute, Seconds present, On exact minute. This is a component-level check for the supplied whole-second timestamps—not a promise about hidden subsecond precision or time import transformations.

Locate entries in the late part of a minute

=SECOND(D3)>=30 has expected Boolean result TRUE for the 16:45:30 row; =SECOND(D2)>=30 is expected FALSE for 09:07:05. Useful for separating source events within a minute before further analysis, but it cannot reconstruct milliseconds not contained in the displayed input or certified by Apple’s page.

If you need elapsed seconds between events, use a deliberately tested date/time subtraction or Numbers duration method; SECOND alone is not an elapsed-time function.

• Component versus elapsed seconds: 16:45:30 is not 30 total seconds after midnight, even though SECOND returns 30.
• Not a rounding control: applying SECOND doesn’t round a timestamp; it extracts one component. For actual rounding or time aggregation, design a separate transformation.
• Zero-leading display: the numeric result 5 does not automatically mean the formatted text "05".
• Missing time type: check that D2 is a date/time value, not text like "not recorded"; Apple’s accepted type also includes a time string, but parsing rules can vary by locale.
• Header/reference mismatch: SECOND(D1) points to a heading if row 1 is a header; use the actual data row.
• Attempted multi-argument call: SECOND has exactly one documented argument. TIME is the three-component constructor.
• Subseconds / DST / timezone: the retrieved function page does not document how to expose milliseconds or certify edge behaviour during daylight-saving transitions. No assertions about those cases are made without native testing.

This tutorial was checked against Apple’s English Formulas and Functions Help 15.4 on 2026-10-11. The 15.4 in a documentation URL describes the help edition. It does not establish a function’s first-supported Numbers release or prove identical execution across macOS, iOS, iPadOS and iCloud.com. Apple documents a Functions Browser in Numbers on Mac, iPhone, iPad and on iCloud.com, but none of those native app editions was used to run these examples. Treat historical releases as unverified unless their own documentation is checked.

Use normal Numbers table references, not Excel worksheet notation: A2 is a same-table cell; Times::D2 is the unambiguous cross-table form when a table named Times is elsewhere on the sheet; Sheet 2::Times::D2 names a sheet and table when required. Apple’s cell-reference help documents the double-colon form. When editing, select the desired cell to have Numbers construct the reference rather than typing a guessed table prefix.

The English examples separate function arguments with commas. Apple’s functions overview instructs users whose regional settings use a comma decimal separator to use semicolons between function arguments when typing by hand. For example, change =TIME(9,7,5) to =TIME(9;7;5), but do not change punctuation inside quoted text. Displayed date/time order and AM/PM appearance are formatting/localization issues, not a different formula signature. Avoid relying on interpretation of ambiguous imported time strings.

The names of these common date/time component functions occur in other spreadsheet products, but matching names do not certify identical handling of imported text, time zones, date serials, errors, or special inputs. The examples here are grounded in Apple’s documented Numbers syntax. Copying Excel Sheet1!D2 references or a Google Sheets tab-qualified formula into Numbers is not a direct substitute for Numbers table references (Times::D2). A number representing clock time is not the same as a duration; elapsed working time across midnight needs a separately designed calculation, not merely a component extractor. Cross-application execution and conversion were not tested.

• COUNTIFS: count records meeting multiple conditions
• SUMIFS: total records meeting multiple conditions

For related time functions, these direct Apple documentation links provide the primary syntax references: TIME, HOUR, MINUTE, SECOND.

• Apple Numbers — function documentation
• cell-reference help
• functions overview
• TIME
• HOUR
• MINUTE
• Apple: Formulas and Functions Help

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.