Date & Time
SECOND Function in Excel
Returns the second of a time value as a number from 0 to 59.
Syntax
- =SECOND(serial_number)
Arguments
- serial_number (required): Time value
Examples
- =SECOND("3:45:30 PM") - Extract second - Result: 30
Excel SECOND function documentation
- SECOND returns the seconds component (0–59) from an Excel time or datetime serial.
- Syntax: =SECOND(serial_number). Pairs with [HOUR](/functions/hour/) and [MINUTE](/functions/minute/) for full time breakdown.
- Use in precision timing, SLA seconds-level checks, and duration diagnostics.
- Related: [TIME](/functions/time/), [NOW](/functions/now/), [TEXT](/functions/text/).
SECOND syntax and precision
- serial_number must be a valid time/datetime value.
- Fractional seconds in the serial truncate — SECOND returns integer 0–59.
- For sub-second display use custom number format on the time cell, not SECOND alone.
- #VALUE! when argument is not a recognizable time.
Step-by-step: build hh:mm:ss from parts
- Step 1 — Use [TIME](/functions/time/)(hour, minute, second) to construct a time.
- Step 2 — Extract parts: =HOUR(A2), =MINUTE(A2), =SECOND(A2).
- Step 3 — Rebuild label: =TEXT(A2,"hh:mm:ss").
- Step 4 — Duration in seconds: =(end-start)*86400.
- Step 5 — Prefer subtraction for elapsed time; SECOND for clock component only.
SECOND vs duration math
- SECOND — component of a timestamp.
- End minus start — true elapsed seconds when multiplied by 86400.
- Category hub: [Date & Time functions](/categories/date-time/).
Worked examples to copy
- Seconds only: =SECOND("10:15:30").
- From NOW: =SECOND(NOW()).
- Zero-pad display: =TEXT(A2,"ss").
- Full time string: =TEXT(A2,"hh:mm:ss").
People also ask
- SECOND range? — 0 through 59 inclusive.
- SECOND on date-only cell? — Returns 0 (midnight).
- SECOND vs millisecond? — Excel SECOND is whole seconds only.
- SECOND in Google Sheets? — Same =SECOND(time_value).
Common errors
- None common
Use cases
- Precise time analysis
- Timestamp processing
- Duration
Frequently asked questions
- What is the SECOND function in Excel? SECOND extracts the seconds component from a time value, returning a number from 0 to 59. It's used for precise time analysis, processing timestamps, and calculating exact durations.
- How do I convert time to total seconds? Use =HOUR(A1)*3600 + MINUTE(A1)*60 + SECOND(A1) to get total seconds. Alternatively, multiply the time value by 86400 (seconds per day): =A1*86400. For 1:30:45, both return 5445 seconds.
- How do I remove seconds from a time value? Use =TIME(HOUR(A1), MINUTE(A1), 0) to set seconds to zero. Or use =TRUNC(A1*1440)/1440 to truncate to minutes. Format the result as time to display without seconds.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use SECOND
- Precise time analysis — common Date & Time scenario for SECOND.
- Timestamp processing — common Date & Time scenario for SECOND.
- Duration — common Date & Time scenario for SECOND.
SECOND in the Date & Time category
- Browse all Date & Time functions at /categories/date-time/ for related formulas.
- SECOND syntax: =SECOND(serial_number)
- serial_number (required): Time value
- Confirm SECOND arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm SECOND arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- HOUR (/functions/hour/): Returns the hour of a time value as a number from 0 to 23.
- MINUTE (/functions/minute/): Returns the minute of a time value as a number from 0 to 59.
- TIME (/functions/time/): Returns the decimal number for a particular time.
Errors to watch for
- None common — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter SECOND on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
SECOND worked examples to copy
- =SECOND("3:45:30 PM") — Extract second. Expected result: 30.
SECOND reference summary for crawlers and offline review
- SECOND belongs to the Date & Time category in Excel. Returns the second of a time value as a number from 0 to 59.
- Full syntax: =SECOND(serial_number). Open /functions/second/ for parameters, FAQs, and related pages.
- Common mistakes: None common
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.