Contact
12 programs
Explore the site

SECOND in Zoho Sheet: Time Formulas and Worked Examples

Date and Time Beginner to Intermediate Zoho Sheet

Read 0–59 seconds from a time for event logs and quality-control timestamps.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked

Quick answer: =SECOND("12:30:53") gives 53. SECOND returns the seconds within the current minute, from 0 to 59, not total seconds elapsed since a starting event. It is useful for event timestamps, logs and checking whether recorded activities started at exact minute boundaries.

Official syntax and argument

=SECOND(time)
Argument Meaning
time The time or date-time value to examine. Zoho’s examples include "12:30:53", "3:15:30PM" and "11:45pm".

Output: integer 0–59. Zoho explicitly shows =SECOND("11:45pm") returning 0 because that time string contains no explicit seconds. A date-only input is treated as 00:00:00 in the official remarks.

Platform, version, and formula punctuation

This guide documents the current official Zoho Sheet help as checked October 11, 2026; the source does not give a first-supported version or a per-device support matrix. The formulas below follow the semicolon-delimited syntax in the Zoho TIME reference. Zoho’s September 2026 What’s New says that the Windows/macOS beta desktop apps use Excel’s native formula syntax by default for offline files. Check the editor’s formula helper for the right punctuation on your device and locale, rather than assuming that the web, mobile, and desktop beta formula parsers behave identically. Zoho’s workbook locale settings also influence display and parsing of dates and times.

Set up the example workbook

Create a sheet with the following eight observations. Enter column B as genuine time values using a recognized 24-hour Time cell format (not plain text). Enter columns C:E as integers. Format column F as Text before entering the shown times, because this column is intentionally used for text-to-time conversion. A CSV import may infer F as a time; if it does, re-enter F as text or use the literal string examples instead. The attached CSV is a source-data aid, not proof that an import preserves these cell types.

Row A: Activity B: Time value C: Hour D: Minute E: Second F: Text time
2 Morning inbound 09:15:40 9 15 40 09:15:40
3 Midday pickup 12:30:05 12 30 5 12:30:05
4 Afternoon review 16:45:30 16 45 30 16:45:30
5 Evening dispatch 22:05:09 22 5 9 22:05:09
6 Overnight check 00:10:00 0 10 0 00:10:00
7 Shift handoff 14:00:00 14 0 0 14:00:00
8 Day-end closure 23:59:59 23 59 59 23:59:59
9 Early dispatch 06:20:15 6 20 15 06:20:15

Keep B as a time and F as text. To eliminate ambiguous text interpretation when troubleshooting, construct known times with TIME(hours;minutes;seconds); note that actual cells may display 12-hour AM/PM or 24-hour times depending on cell format and locale.

Reproducible formula steps

  1. Enter =SECOND(B2) in G2. With B2=09:15:40, the result is 40.
  2. Copy G2 down to G9: expected results 40, 5, 30, 9, 0, 0, 59, 15.
  3. Test the documented literal =SECOND("12:30:53"): expected 53.
  4. Observe B7=14:00:00: SECOND is 0, not 60 or an empty cell.
Formula Expected Context
=SECOND(B3) 5 Five seconds past 12:30
=SECOND(B4) 30 Mid-minute review
=SECOND(B6) 0 00:10 sharp
=SECOND(B8) 59 Final second in the minute

Advanced use: standardize timestamps to the nearest minute downward

Remove seconds from a time by rebuilding its clock components:

=TIME(HOUR(B2);MINUTE(B2);0)

For B2=09:15:40 the expected displayed time is 09:15:00; for B8=23:59:59, 23:59:00. This truncates the seconds; it does not round to the nearest minute. It also drops any original date, since TIME creates a time-of-day value. Don’t use it to reconstruct a complete date-time stamp without adding the date component separately.

Calculate seconds since midnight:

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

For B2 the result is 33340 (32,400 + 900 + 40); for B3 it is 45005 (43,200 + 1,800 + 5). This counts from midnight, not elapsed duration across days.

Error and precision notes

  • False expectation of 60: SECOND’s range ends at 59; a displayed time without seconds yields zero.
  • Time cells incorrectly stored as text: Test =TIME(9;15;40) first. The SECOND of that result should be 40 if the locale/editor accepts documented syntax.
  • Hidden seconds: A cell formatted as 09:15 may still contain 09:15:40; change display formatting before assuming data loss.
  • Date-only input: Zoho’s midnight rule yields second 0.
  • Errors: #VALUE! can indicate incompatible input; #NAME! malformed formula or unknown function; #REF! invalid reference.
  • Subseconds: Zoho’s cited reference does not document fractional-second handling or rounding guarantees. Do not infer them from another spreadsheet without native testing.

Alternatives and cross-software compatibility

Excel and Google Sheets also provide SECOND, but date serial epochs, string parsing and fractional-second rules should be tested separately. Prefer constructing a time with Zoho’s documented TIME rather than relying on an imported timestamp string. For duration calculations spanning midnight, retain date-time information rather than summing SECOND components.

Official reference and verification

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

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