ExcelDateBeginner

MINUTE

Returns the minute as a number from 0 to 59.

Read the syntaxReview worked examplesOpen the spreadsheet app
=MINUTE(serial_number)
Open Spreadsheet Explorer

This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.

What the function does

Overview

Returns the minute as a number from 0 to 59.

The MINUTE function extracts the minute component from a time value represented by an Excel serial number. The result is an integer ranging from 0 to 59. This function is valuable for precise time analysis, allowing you to isolate and work with the minute portion of a time. The `umber` argument can be a number representing a date and time, a text string that Excel can parse as a time (e.g., "3:45 PM"), or the result of another function that returns a time value (like NOW() or TIME()). Similar to HOUR, if the `umber` is a text string that Excel cannot interpret as a time, MINUTE will return a #VALUE! error. It's essential to understand that Excel's date and time system uses serial numbers, where the decimal part represents the time of day. MINUTE specifically targets this decimal part to extract the minute, ignoring any date component.

Quick reference

Syntax

=MINUTE(serial_number)

Inputs

Arguments

serial_numberA number in a date-time format or a text string representing a time.
Example: B2

Formula patterns

Examples

1

Extracting minute from a time string

=MINUTE("10:25:05 AM")
time extractiontext to number
2

Extracting minute from a cell with a time

=MINUTE(B2)
date-time analysistime component

Avoid these issues

Common Errors

1

#VALUE!

Cause: The 'serial_number' argument cannot be interpreted as a valid time by Excel.

Fix: Ensure the 'serial_number' is a valid Excel date/time serial number or a text string in a recognized time format.

2

#NUM!

Cause: The 'serial_number' argument is a number that is outside the valid range for Excel dates/times (e.g., a negative number).

Fix: Provide a valid positive serial number representing a date and/or time.

Platform support

Compatibility

Excel 2007+Google Sheets

Available in Excel 365 and earlier versions.

Source: Microsoft Support

Common questions

Frequently Asked Questions

Returns the minute as a number from 0 to 59.

umber: A number in a date-time format or a text string representing a time.

#VALUE!: Ensure the 'umber' is a valid Excel date/time serial number or a text string in a recognized time format. #NUM!: Provide a valid positive serial number representing a date and/or time.