TIME Function in ONLYOFFICE Spreadsheet Editor: Syntax, Worked Examples and Checks

Construct a time-of-day value from separate hour, minute and second numbers. In the official English reference, use TIME(hour, minute, second). All outputs here are independent expected results, not results observed in ONLYOFFICE. Official TIME documentation.

Create reproducible spreadsheet times from integer components, avoiding locale-ambiguous time text. Use this function in a time-of-day reporting column, for checking imported clock readings or as one piece of a more explicit scheduling formula. A displayed time and its numeric day fraction are different views of the same intended value. If you need an elapsed duration, first decide how dates, overnight crossings and missing values are represented; extracting a clock component is not a complete duration calculation.

=TIME(hour, minute, second)

The official TIME reference documents a time value displayed according to cell format (vendor mentions hh:mm tt by default). The arguments appear in the following order:

All three arguments are supplied in the official signature; the reference does not specify an omitted-argument default. Its listed ranges are the safe values used here. The vendor describes an initial display like hh:mm tt; for seconds, use a format displaying hh:mm:ss. The reference does not define how out-of-range values are normalized or rejected, and this guide makes no such claim. TIME vendor reference; Insert Time walk-through.

The current ONLYOFFICE Spreadsheet Editor function catalogue lists the function, and the dedicated official page documents its English signature. These pages are not a version-by-version execution matrix. The first Docs release, first Desktop release, and supported mobile builds for this specific function are not established here. The Docs changelog and Desktop changelog are separate histories; no unsubstantiated introduction version is assigned.

• Docs / web editor: documented in the generic Spreadsheet Editor help. Verify the exact server and editor build where a workbook will be used; this research did not open a running Docs environment.
• Desktop Editors: a separate product and release history. No installed Windows, macOS or Linux Desktop Editor was used to calculate these examples; do not infer tested desktop behaviour from the Docs help page.
• Mobile, integrations and old builds: not tested and not guaranteed by the function’s unversioned entry. If a formula is unexpectedly unsupported, check the build and its Insert Function picker before adapting the workbook.
• Formula language: Advanced Settings documents a Formula Language setting. The formulas here intentionally use English function names and the comma-separated syntax given in the English reference and Insert Functions guide. A non-English installation can show translated function names; do not assume that English text can always be pasted unchanged.
• Region and display: the same settings page documents Region, time-display differences and configurable decimal/thousands separators. It does not promise one universal interpretation of ambiguous text such as "03:04" across languages. These workbook exercises rely on numeric arguments created with TIME, avoiding most free-text parsing ambiguity.
• Date system: the same page documents a 1904 date system option. The sample table uses pure clock times, but combining times with calendar dates in other workbooks requires knowledge of the source date serial system. This analysis does not claim equality at 1900/1904 boundaries.

Evidence access date: 2026-10-11 (UTC). The general official index was previously enumerated as 484 documented names on 2026-10-11; the four entries in this batch were spot-checked again, not a new census of all function names. There are no claimed native execution results in this guide.

Create a new worksheet and enter the headings below. Type numbers, not quoted text, into columns A–C. In D2, enter =TIME(A2,B2,C2), then fill down to D9. Format D2:D9 explicitly as a time with seconds (hh:mm:ss when available). In E2, enter =HOUR(D2); in F2, enter =MINUTE(D2); in G2, enter =SECOND(D2); fill each down to row 9. The following is a Python Fraction arithmetic fixture, not an ONLYOFFICE execution transcript.

The D-column times are built from the practice sheet below. These are expected outputs computed independently of ONLYOFFICE, not observed results. Enter the formulas in empty cells (e.g., J2 onward) to compare:

1. Assemble a time from imported numeric columns

With A4=13, B4=39, C4=15, enter =TIME(A4,B4,C4) into D4. Apply a hh:mm:ss time display format.

Independently calculated expectation: Expected display 13:39:15, and numeric fraction 49155/86400 ≈ 0.5689236111.

Boundary and interpretation: The displayed string depends on format and region. For reliable input, store numeric components rather than ambiguous time strings.

2. Compute elapsed hours on the same day

Enter =(TIME(17,0,0)-TIME(9,30,0))*24 in J4 and use a plain number format.

Independently calculated expectation: Expected 7.5 hours.

Boundary and interpretation: This assumes both times are on the same calendar day. TIME builds clock values; it does not encode which date an event occurred.

3. Add a fixed number of minutes

Enter =TIME(9,5,7)+20/1440 and apply a time format with seconds.

Independently calculated expectation: Expected 09:25:07.

Boundary and interpretation: There are 1,440 minutes in a day. Adding 20/1440 adds a fractional day; the example stays inside the same day.

4. Reconstruct a time from its component functions

Enter =TIME(HOUR(D4),MINUTE(D4),SECOND(D4)) and format with seconds.

Independently calculated expectation: Expected 13:39:15 when D4 comes from TIME(13,39,15).

Boundary and interpretation: This can discard hidden fractional seconds if any; the official pages do not state precision guarantees for such roundtrips.

5. Handle a simple overnight time span deliberately

Use =MOD(TIME(1,15,0)-TIME(23,30,0),1)*24 for a start at 23:30 and a following-day end at 01:15.

Independently calculated expectation: Independently expected 1.75 hours (105 minutes).

Boundary and interpretation: This is an independent arithmetic expectation for an interval shorter than a day. MOD compatibility and actual formula execution were not native-tested this run; a calendar-date column is better for multi-day spans.

1. Create a fresh spreadsheet in your chosen editor and confirm it is in edit mode.
2. Set Formula Language and Region intentionally in Advanced Settings. These examples use the English function names and commas.
3. Enter the fixed numerical input values in the practice sheet. Use the Formula tab or the official Insert Function instructions to confirm the available name and argument order.
4. Enter the example exactly as written, including the leading =. If it is shown literally as text, remove text-only formatting and re-enter in a formula-capable cell.
5. Select D2:D9 and format as time with visible seconds. Select E:G as General/Number, not date or time. If the cell shows a fraction rather than a clock, check the number format before changing the formula.
6. Compare each observed result to the independently calculated expectation. For production workflows, record the editor product, build, operating system/browser, formula language, region and workbook date system alongside any test results.

The official Insert Functions guide also documents recalculating via Formula → Calculation; if an output looks stale after editing referenced cells, trigger recalculation before troubleshooting a formula.

1. Display vs value. TIME constructs a numeric time value. General format may show a fraction such as 0.5; an hh:mm:ss format shows 12:00:00. These are representations of one intended time.
2. Out-of-range inputs. The ONLYOFFICE help states hour 0–23, minute 0–59 and second 0–59. It does NOT document how the editor processes TIME(25,0,0), negatives or fractions. Excel may normalize some inputs; do not copy that assumption to ONLYOFFICE.
3. Omitted arguments. All three arguments appear in the published signature; this guide uses an explicit zero rather than omitting components.
4. Times do not contain dates. TIME alone does not distinguish today at 01:00 from tomorrow at 01:00. Combine with a date when calculating spans across midnight.
5. Formatting can hide seconds. Official help mentions hh:mm tt as a default display; set hh:mm:ss if seconds matter.

Unexpected error or missing function: The official quick reference does not give a complete error-code matrix for blanks, boolean inputs, malformed time text, negative values, out-of-range TIME fields or locale-specific parsing. No specific #VALUE!, #NUM!, or #NAME? behaviour is claimed as observed in ONLYOFFICE. If a workbook produces one of these, capture the exact formula, source cell values/types, installed edition/version, selected formula language and screenshot, then compare against a control using valid numeric TIME values. If a time is present but seems wrong, try displaying the underlying value in General format and explicitly applying a seconds-visible time format.

Avoid near-boundary floating-point assertions: Fractional-day values can be represented in floating point. SECOND/MINUTE expectations for noninteger times close to a roll-over boundary were not natively established by these independent integer-second fixtures. If precision is operationally important, collect real installed-build test results before treating a boundary case as supported.

The LibreOffice TIME reference uses the same conceptual three-part time construction but displays its formula syntax with semicolon separators; ONLYOFFICE’s English help uses commas. This is not a guarantee of identical out-of-range coercion or stored precision.

Why did TIME(12,0,0) display 0.5?

A spreadsheet time can be represented as a fraction of a 24-hour day. Half of a day is noon. Apply a time number format to see 12:00:00.

Can I write TIME(13,75,0)?

The official ONLYOFFICE reference describes minute as 0–59. Behavior outside that range must be tested; do not depend on normalization.

Does TIME store a date?

No date is supplied in this function’s published arguments. Combine a date value and time fraction when date context is required.

• TIME: build a time from hour, minute and second.
• HOUR: extract the hour.
• MINUTE: extract the minute.
• SECOND: extract the second.
• DATE: create a date from year/month/day components.
• Advanced Settings: Formula Language, Region and 1904 date system.

• ONLYOFFICE Spreadsheet Editor — function documentation
• Insert Time walk-through
• current ONLYOFFICE Spreadsheet Editor function catalogue
• Docs changelog
• Desktop changelog
• Advanced Settings
• LibreOffice TIME reference

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

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.