Calligra Sheets MINUTE Function: Extract the Minute from a Time

MINUTE extracts the minute-of-hour component (0–59) of a time. For a real typed time 14:35:42, =MINUTE(TIME(14;35;42)) has expected result 35. This is useful when building a scheduling, reporting or time-quality-check worksheet. It does not return a full time or elapsed duration. The source also registers MINUTES with the same implementation callback; MINUTES is covered here as a synonym rather than a separate calculation.

Version, scope and validation: This guide is based on KDE’s handbook and Calligra 26.08.2 source (KDE release dated October 8, 2026; sources checked October 12, 2026). The pinned source comes from commit 72123cc643f6625351139e7df294544255a1056f. The source and handbook establish registrations and intended behavior for that code snapshot, not a guarantee for every binary, platform, installation or imported file. Calligra Sheets was not run in this research. Every worksheet number labeled expected is independently calculated or drawn from a documented KDE example; none is a screenshot or result observed in a native build.

=MINUTE(time)
=MINUTE()
=MINUTES(time)

• time — optional, first and only argument. KDE’s English-language handbook describes the time argument as Text; the compiled function registration permits zero or one argument (setParamCount(0, 1)), and the callback passes a supplied value through Calligra’s asTime() converter. That allows a typed time value as well as documented accepted time expressions, but does not prove that every user-entered string will parse in every locale.
• Omitted argument: =MINUTE() takes the current local time, then returns its minute component. It has no fixed default time. Its output changes with the clock and evaluation; do not hardcode an expected number for an unrecorded test run.
• Return type: KDE calls this a whole number; the pinned callback returns an integer Value. The conceptual minute component is 0–59 for ordinary nonnegative clock times.
• Argument order: with one argument, supply a single time expression or cell reference. It does not take separate hours, minutes, seconds. If you have separate components, construct a time first using TIME(hours;minutes;seconds).

Regional settings: Formulas in the KDE English handbook use ; between multiple parameters (as in TIME(14;35;42)). An installed spreadsheet might show a different separator, different 12/24-hour display, localized time literals or comma decimal separators. Check your local formula editor. For reusable examples, use TIME() with numeric arguments rather than assuming that the literal text "02:03:04" parses identically everywhere. Do not mistake a visually formatted date/time string for a typed spreadsheet time.

Open a new Calligra Sheets worksheet. In A1, type Typed time; in B1, type MINUTE result. Enter each formula below into column A; enter the corresponding =MINUTE(A2)-style formula into column B. Copy B2 down to B7. Format A2:A7 as time (hh:mm:ss) if needed, while leaving B as ordinary numbers.

How these were checked: TIME(h;m;s) in the examined KDE code creates an internal Time from three numeric components. The MINUTE callback extracts its minute property. I independently parsed the six entered h:m:s triplets to obtain the listed expected integers. Native execution: unavailable. The cell’s displayed time could differ with regional formatting, but the canonical 24-hour components are unambiguous for these controlled inputs.

To verify a result yourself, check that A3 represents 14:35:42, select B3 and inspect the formula bar. If B3 disagrees with the independently computed 35, confirm that A3 is a time value, not a string that merely looks like one, and that the installed Calligra version has the same semantics.

The direct nested formula =MINUTE(TIME(14;35;42)) → 35. This removes any dependencies on cell formatting or copy/fill operations and is the safest initial calculation to compare across installations.

KDE documents =MINUTE("22:10:12") → 10 and =MINUTE(0.1234) → 57; these are handbook examples. The decimal illustrates a fraction-of-day time representation, but parsing and display are not independently executed here.

The documented fractional-day examples should not be confused with an unconditional promise that arbitrary text timestamps, invalid dates or nonstandard input serials have identical behavior in Excel and Calligra. The native parsing and representation of fractional times were not tested.

In an arrivals dashboard, use =HOUR(A3)*60+MINUTE(A3) to compute 875 minutes past midnight, then group times into 15-minute intervals with =INT((HOUR(A3)*60+MINUTE(A3))/15); at 14:35 the expected slot is 58 (zero-based). The formula intentionally drops seconds; for precise slot boundaries involving seconds include SECOND(A3)/60 before division. Native time-zone, daylight-saving and imported-text behavior still require testing.

Second independent calculation: =MINUTE(A3)+SECOND(A3)/60 is expected to return 35.7 for 14:35:42. It is minutes within the hour, with a fractional-minute addition, not elapsed minutes since midnight. This calculation is based on the same typed times used above, without asserting that the formula ran in a native Calligra installation. If time is imported as text, explicitly parse or enter it as time before applying the extraction function, and verify the result in the target locale.

For complete duration arithmetic, work with full timestamps and appropriate formatting rather than extracting the minute component and assuming it reflects elapsed time. Time zones and daylight-saving adjustments belong in timestamp handling, not in these component functions.

The callback returns time.minute() from an internal Time converted by asTime(). There is no rounding-to-minute performed by this function in its source. A time of 14:35:42 therefore contributes 35, not 36, in the controlled example.

• Missing value versus omitted argument: =MINUTE() has intentional current-clock semantics; =MINUTE(A8) when A8 is blank presents an explicit reference, and its conversion behavior is a separate question. Do not infer the latter from the former. The actual blank-cell result requires native validation.
• Invalid or non-localized text: A malformed text input is converted by asTime(); the callback passes through a conversion error if returned. Do not invent the exact error text or localized parsing outcome. The return code and text displayed in the user interface are not verified here.
• Stored number versus visible time: A cell can look like 14:35:42 while containing a text label. Inspect the formula bar and use TIME() to distinguish display formatting from conversion. Values outside ordinary clock ranges may be normalized by the input-conversion routines or rejected; avoid unverified assumptions.
• Alias and file interchange: The source registers MINUTES to the same callback. When exporting to another spreadsheet application, the plural name may not be supported as a function there. The canonical singular name is preferable for portability.
• Platform/edition scope: This evidence is pinned to one KDE source release; native Windows/macOS packaging, downstream patches, locales and spreadsheet file conversions have not been separately exercised.

The plural MINUTES name is registered as a distinct entry pointing to the same function callback, not a separate calculation rule; use MINUTE as the canonical name.

Calligra 26.08.2: MINUTE accepts 0–1 arguments, and MINUTES maps to the same implementation (per KDE registration). The callback converts an explicit argument to Time and reads its minute component (per source). Microsoft Excel: Microsoft Excel documents MINUTE(serial_number), with the argument required. Calligra allows MINUTE() for the current minute; do not port this invocation unchanged to Excel. Microsoft documentation is used only to describe Excel, not as proof of Calligra behavior.

What is likely portable: =MINUTE(A2) where A2 contains a conventional, properly typed 24-hour time. What is not automatically portable: the no-argument form, the alternate plural name, localized textual inputs, unusual duration values. Check the destination application’s formula separator and time interpretation before trusting a migrated workbook.

1. Unexpected value: Compare against a nested typed-time formula, =MINUTE(TIME(14;35;42)) → 35. If this works but a referenced cell does not, inspect its underlying value or text format.
2. Formula name not recognized: Check exact spelling MINUTE and the target version. MINUTES is source-registered in Calligra 26.08.2 but does not mean all spreadsheet products recognize it.
3. Wrong hour or minute after import: Confirm whether the source uses a 24-hour time, has AM/PM suffixes, and includes a date or time zone. Convert consistently before extracting components.
4. Error on a typed string: Compare a literal documented example with TIME(h;m;s). If only the string fails, suspect locale-aware text parsing. Record the exact application version and observed error.
5. Unexpected change when revisiting sheet: Avoid the no-argument invocation for fixed historical records: it reads the current clock, not a saved event timestamp.
6. Duration exceeds 24 hours: Use an actual duration/timestamp calculation, not a component value. A formatted 26-hour duration is not guaranteed to return a total of 26 hours from HOUR.
7. Native source inconsistency: Use a known TIME input and compare with this evidence; report the installed platform, locale, exact formula and observed result to the editor. The native check is pending, not silently presumed successful.

• KDE’s official MINUTE handbook section — documents the purpose, text-labeled parameter, examples and no-argument behavior. Accessed 2026-10-12.
• KDE’s TIME handbook section — supplies reproducible numeric time construction. Accessed 2026-10-12.
• KDE’s MINUTES handbook entry — distinct heading; same implementation in the pinned release. Accessed 2026-10-12.
• Pinned KDE function registrations and pinned time-extraction callback — review source-specific arity, aliases, conversion and error behavior. Verified against pinned commit 72123cc643f6625351139e7df294544255a1056f on 2026-10-12.
• Official KDE Calligra release history — lists 26.08.2 dated 2026-10-08. Accessed 2026-10-12.
• Microsoft’s Excel MINUTE reference — comparative Excel-specific required argument and range. Accessed 2026-10-12.