Learn How to Use Microsoft Excel MINUTE Function

Microsoft Excel MINUTE Function

The MS Excel MINUTE function is used to extract minutes as a number from time. That means the MINUTE function returns the minute as a number from a time from 0 - 59. Let's say, for example, with the given time 10:45 AM, and MINUTE will return 45. So with the MINUTE function, you can extract the minute into a cell or can also feed the result into another function like the TIME function.

MINUTE Function Return Value

It will return the number between 0 to 59.

MINUTE Function Syntax

= MINUTE(serial-number)

Where:

• serial-number: A valid Excel date or time.

How to Use Microsoft Excel MINUTE Function?

As we know, the MINUTE function extracts the minute from a time as a number from 0 to 59; let's understand this as an example given below:

Example 1:

• = MINUTE("10:45 AM") - This will return the value 45.
• = MINUTE("09:15 PM") - This will return the value 15.

Example 2: You can also use the MINUTE function to extract the minute into a cell or feed the result into another function like the TIME function. Let's say the time in cell A1 is 6:45 PM, and you can create a new time including 45 minutes as given below:

• =TIME(8, MINUTE(A1), 0) - This will return the time 8:45 PM.

Check out the list of all other articles:

• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel
• Learn How to Sort Birthdays by Month and DAY in Microsoft Excel