Quick Navigation

MINUTE Function

Excel 2007+

Summary

The Excel MINUTE function extracts the minute component from a time value, returning an integer between 0 and 59. It's essential for time analysis, scheduling, and breaking down datetime values into individual components for calculations and reporting.

Syntax

MINUTE(serial_number)

Parameters

Parameter	Type	Required	Description
serial_number	`Time`	Yes	The time containing the minute you want to extract. Accepts text strings, decimals, or formulas.

Using the MINUTE Function

MINUTE is perfect for parsing time values in reports, schedules, and analytics. Use it to isolate minutes from timestamps for conditional formatting, time calculations, or data validation.

Common MINUTE Examples

Basic Time Extraction

=MINUTE("12:45 PM")

Extracts 45 minutes from the time text string.

Cell Reference

=MINUTE(A2)

Returns minutes from time value in cell A2 (e.g., 12:45:00 PM returns 45).

Decimal Time

=MINUTE(0.78125)

Converts decimal fraction (6:45 PM) to minutes (45).

With TIMEVALUE

=MINUTE(TIMEVALUE("6:45 PM"))

Processes text time through TIMEVALUE first, returns 45.

Frequently Asked Questions

Returns #VALUE! error. Ensure input is valid time format.

Yes, extracts minutes from datetime values, ignoring date portion.

Always 0-59 as integer.

Common Errors and Solutions

#VALUE!

Cause: Invalid time format in serial_number

Solution: Use valid time text, decimal, or TIMEVALUE formula

#N/A or other errors

Cause: Formula references contain errors

Solution: Fix upstream formula errors

Notes

Time values are decimals (12:00 PM = 0.5)
Combines with HOUR() and SECOND() for full time breakdown
Processes times entered as text strings directly
Available since Excel 2000

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365, Excel for Web

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+