Extract the minute-of-hour component, from 0 through 59, from a spreadsheet time value. In the official English reference, use MINUTE(serial_number). All outputs here are independent expected results, not results observed in ONLYOFFICE. Official MINUTE documentation.

Read the minute field of a clock time; do not confuse it with elapsed minutes since midnight. 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.

=MINUTE(serial_number)

The official MINUTE reference documents an integer from 0 through 59. The arguments appear in the following order:

Only one required parameter is shown. This guide deliberately avoids assuming undocumented type coercion, rounding of noninteger seconds, or handling of negative serials. The time serial may represent a fraction of a 24-hour day; for example the vendor describes decimal 0.56 as 13:26 and, in the SECOND reference, explicitly 13:26:24. This is an example of the time-component model, not a claim that a digit sequence such as 0.56 should be read as decimal-clock notation.

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. Create five-minute reporting bins

In J4 enter =5*INT(MINUTE(D4)/5) for D4 = 13:39:15.

Independently calculated expectation: Independently expected 35, meaning the start of the 13:35–13:39 minute bin.

Boundary and interpretation: The function returns a minute number, not a full clock time. Combine the hour with the bin if you need an unambiguous timestamp.

2. Capture minute components from a column

Enter =MINUTE(D2) into F2 and fill down to F9.

Independently calculated expectation: Expected 0, 5, 39, 59, 0, 30, 45, 2.

Boundary and interpretation: This works well for minute-of-hour groupings, but cannot distinguish 09:05 from 17:05.

3. Extract minutes from an expression with date and time

Enter =MINUTE(DATE(2026,10,11)+TIME(22,47,30)) in J5.

Independently calculated expectation: Expected 47.

Boundary and interpretation: This assumes valid integer TIME arguments and the conventional fractional-day interpretation. Validate on your target application.

4. Compute elapsed minutes rather than clock minutes

For a same-day pair of times, enter =(TIME(10,15,0)-TIME(9,45,0))*1440.

Independently calculated expectation: Expected 30 elapsed minutes; MINUTE(TIME(10,15,0)) alone is 15.

Boundary and interpretation: Direct subtraction is for same-day intervals in this example; overnight intervals require an explicit rollover rule.

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. Duration versus component. MINUTE(13:39:15) reads 39; it does not return 13*60+39 = 819 elapsed minutes.
2. Decimal fractions are not decimal clock notation. 0.56 is 56% of a day, not 0 hours and 56 minutes. ONLYOFFICE cites this example and shows approximately 13:26.
3. Leading zeros are a display choice. A numeric result of 5 is not the text “05”; apply a numeric display format if two digits are needed.
4. Ambiguous imported text. Avoid unqualified AM/PM or regional text imports until parsed and validated in the target editor.

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.

MINUTE is also available in Excel and LibreOffice Calc with analogous minute-component intent, but string parsing, input type coercion and regional separators have not been equivalence-tested here.

Why does 09:05:07 return 5, not 05?

MINUTE returns a number; leading zeros are presentation formatting.

Does MINUTE return the full duration in minutes?

No. It returns the minute position in the clock hour, 0–59.

How do I get total elapsed minutes?

Subtract verified time values, then multiply the fractional-day difference by 1,440. Handle crossing midnight deliberately.

• 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
• current ONLYOFFICE Spreadsheet Editor function catalogue
• Docs changelog
• Desktop changelog
• Advanced Settings
• TIME: build a time from hour, minute and second
• HOUR: extract the hour

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.