Contact
12 programs
Explore the site

MINUTE Function (LibreOffice Calc)

Date & Time Beginner LibreOffice Calc Introduction not established

The MINUTE function extracts the minute component (0–59) from a time or datetime value. It is essential for time analysis, scheduling, and cleaning imported timestamp data.

Verification status: Consult the documentation, examples and any stated test scope below. How formula examples are checked

Availability and version history

  • Introduced: Documented by LibreOffice 26.8.1.1; original introduction not established.
  • Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
  • Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
  • Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.
The **MINUTE** function extracts the **minute component (0–59)** from a time or datetime value. It works with real times, serial numbers, and text converted with TIMEVALUE. MINUTE is essential for timestamp parsing, dashboards, scheduling logic, and cleaning imported data.

What the MINUTE Function Does

  • Extracts the minute from a time or datetime
  • Accepts serial numbers, real times, or converted text
  • Returns an integer from 0 to 59
  • Ignores hours and seconds

It is designed to be simple, reliable, and ideal for time‑component extraction.

Syntax

MINUTE(time_value)

Arguments

  • time_value:
    A time, datetime, or serial number representing a time.

Basic Examples

Extract minute from a time

=MINUTE("14:30")

Returns 30.

Extract minute from a datetime

=MINUTE("2024-03-15 08:45")

Returns 45.

Extract minute from a cell

=MINUTE(A1)

Extract minute from NOW()

=MINUTE(NOW())

Advanced Examples

Extract minute from text using TIMEVALUE

=MINUTE(TIMEVALUE(A1))

Extract minute from a timestamp with seconds

=MINUTE("18:22:59")

Returns 22.

Extract minute from a serial number

=MINUTE(0.75)

0.75 days = 18:00 → returns 0.

Extract minute from imported CSV timestamps

=MINUTE(DATEVALUE(LEFT(A1;10)) + TIMEVALUE(MID(A1;12;8)))

Extract minute from ISO datetime

=MINUTE(TIMEVALUE(MID(A1;12;8)))

Extract minute from Excel serial dates imported as text

=MINUTE(DATE(1899;12;30)+VALUE(A1))

Bucket minutes into 15‑minute intervals

=INT(MINUTE(A1)/15)*15

Check if a time is on the hour

=MINUTE(A1)=0

Check if a timestamp is within a specific minute range

=AND(MINUTE(A1)>=10; MINUTE(A1)<=20)

Edge Cases and Behavior Details

MINUTE returns an integer (0–59)

Accepts:

  • Real times
  • Datetimes
  • Serial numbers
  • TIMEVALUE outputs

Invalid text → Err:502

MINUTE ignores date components

=MINUTE("2024-03-15 22:10") → 10

MINUTE ignores hours and seconds

MINUTE of a number > 1

=MINUTE(1.5) → 0  
(1.5 days = 36:00 → minute = 0)

MINUTE of negative values → Err:502

MINUTE of an error → error propagates

Common Errors and Fixes

Err:502 — Invalid argument

Cause:

  • Text not recognized as a time
  • Negative serial numbers
  • Non-numeric values

Fix:

  • Wrap with TIMEVALUE
  • Clean text with TRIM or SUBSTITUTE

Wrong result due to date formatting

Fix:

  • Ensure the cell contains a real datetime, not text

Unexpected minute from serial numbers

Cause:

  • Serial numbers represent days, not hours

Fix:

  • Use MOD(A1;1) to isolate time portion

Best Practices

  • Use MINUTE for all minute‑extraction tasks
  • Use TIMEVALUE to normalize text times
  • Use INT or MOD to isolate time components
  • Use MINUTE with NOW() for dynamic dashboards
  • Use MINUTE with logical tests for scheduling rules
MINUTE is your timestamp‑cleaning scalpel — perfect for dashboards, scheduling logic, time analysis, and parsing messy imported data.
  • Use HOUR and SECOND for other components
  • Use TIME to construct times
  • Use TIMEVALUE to convert text
  • Use NOW for current datetime
  • Use DATE for date construction

By mastering MINUTE and its companion functions, you can build powerful, reliable, and fully dynamic time‑based workflows in LibreOffice Calc.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

=MINUTE(TIME(14;30;0))

Expected result: 30.

Extract minutes from a time value.

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.