MINUTE Function (LibreOffice Calc)
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.
Compatibility
▾| Excel | ✔ |
| Gnumeric | ✔ |
| Google_sheets | ✔ |
| Libreoffice | ✔ |
| Numbers | ✔ |
| Onlyoffice | ✔ |
| Openoffice | ✔ |
| Wps | ✔ |
| Zoho | ✔ |
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.
Related Patterns and Alternatives ▾
- 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.