How to Use MINUTE Function in Excel (6 Examples)

The MINUTE in Excel is a built-in function that is classified as a Date/Time function. It can be found on the Formulas tab of the Ribbon.

In this article, I’ll discuss the ins and outs of the function, starting from the basics to VBA code, including six practical examples.

MINUTE Function in Excel (Quick View)

MINUTE Function in Excel (Quick View)

Download Excel Workbook

Excel MINUTE Function: Syntax & Arguments

Now, we’ll see the syntax and argument of the function. If you insert the function after entering equal sign (=), you’ll see the following type of scenario.

The MINUTE formula

Summary

The MINUTE function returns the number of minutes in a given time value. For example, if the time value is given as “10:30 AM”, the function will extract 30 minutes.

Return Values

0 to 59 (in number format)

Syntax

=MINUTE (serial_number)

Arguments

Argument Required or Optional Value
serial_number  Required A valid time value

Note. In the previous version of Excel, you couldn’t enter the time value without quotations. But in Microsoft 365, it is possible. Besides, the serial number would be fractional, as you know the positive integer serial number represents a particular day in Excel.

How to Use the MINUTE Function in Excel ( Examples)

Example 1: Pulling Minutes from Time Value Using MINUTE Function

You can extract the number of minutes using the function easily. The time value may be in 9 types of different formats. However, you’ll get an accurate value.

If you look at the second example of the following figure, the time value is given as hh:mm:ss e.g. 10:40:00 AM.

Right now, insert the following formula.

=MINUTE(B6)

Here, B6 is a type of time value.

Pulling Minutes from Time Value Using MINUTE Function

You can use the Fill Handle Tool to calculate the number of minutes for the other formats of time value. But if you want to extract the current minute, you should enter the following formula.

=MINUTE(NOW())

Note. The NOW function returns the current time.

Example 2: Combination of TIME and MINUTE Functions

Imagine you have an hour value, and you want to produce a new time with a new minutes value regarding that hour value. You can use the following formula.

=TIME(7,MINUTE(B5),0)

Here, B5 is a time value.

Combination of TIME and MINUTE Functions

Example 3: MINUTE Function with IF Statements

The IF function is mainly used to verify logical statements. For example, the time value is provided with a condition e.g. the time value will be counted if it is less than 30 minutes otherwise the value will be 0. In that case, you may utilize the combination of IF and MINUTE functions.

=IF(MINUTE(B5)<30,B5,0)

Here, B5 is a time value.

MINUTE Function with IF Statements

Example 4: Producing A New Time

Now, we’ll see some interesting stuff. Assuming that starting time (time starts), and the required minutes of a session are given, you have to find the end time (time ends) of the session.

Just, enter the following formula

=TIME(HOUR(B5),MINUTE(B5)+C5,SECOND(B5))

Here, B5 is a starting time and C5 is the required minutes.

Read more: How to Use SECOND Function in Excel

Example 5: Computing Difference in Minutes

Also, you can calculate the difference in minutes between two times e.g. starting time and ending time.

In such a situation, you may employ the MINUTE formula.

=MINUTE(C5-B5)

Here, C5 is the ending time and B5 is the starting time.

Note. In this example, the MINUTE function ignores the differences in hours and seconds.

Computing Difference in Minutes

Example 6: MINUTE Function in VBA

If you have a larger dataset, it is time-consuming and a little bit boring to get the required result using a formula.

Rather you can utilize the VBA code in Excel which performs the result rapidly and accurately.

Now, let’s see how you can apply the VBA code to calculate the number of minutes.

Firstly, open a module by clicking Developer>Visual Basic>Insert>Module.

Then, copy the following code in your module.

Sub example_MINUTE()
Range("D5").Value = Minute(Range("B5"))
End Sub

Here, two basic things to consider.

  • Range: The cell where you want to extract the number of minutes
  • Minute_Range: The cell from which you want to extract the number of minutes

Note. If any invalid date format is used while running the code, you’ll see a run-time 13 error.

MINUTE Function in VBA

Common Errors While Using the MINUTE Function

Common Errors When they show
#VALUE! – When any invalid time format is inserted as a serial number

Conclusion

This is how you can apply the MINUTE function to calculate the number of minutes. Also, you have the opportunity to combine the function with other Excel functions. If you have an interesting and unique method of using the MINUTE function, please share it with us.

Thanks for being with me.


Further Readings

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo