How to Use MINUTE Function in Excel (6 Suitable Examples)

• Version

All versions of Microsoft Excel have the MINUTE function.

How to Use MINUTE Function in Excel: 6 Suitable Examples

To use the MINUTE function in Excel, we have found six different examples so that you can have a clear idea about this topic. Here, we would like to utilize several examples including VBA code, MINUTE function, and a combination of MINUTE and other functions. When you go through these examples, you may gather profound knowledge regarding the MINUTE function.

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. First of all, we take a dataset including some time value and its format. We would like to figure out the minutes using the MINUTE function.

To understand the example, follow the steps.

Steps:

• First, select cell D5.
• Then, write down the following formula.

• Press Enter to apply the formula.

• After that, drag the Fill Handle icon down cell D12.

• Then, in cell D13, we would like to find the current minutes from the current value.
• So, write down the following formula.

• Press Enter to apply the formula.

2. Combination of TIME and MINUTE Functions in Excel

Imagine you have an hour value, and you want to produce a new time with a new minutes value regarding that hour value. In this example, we would like to use the combination of TIME and MINUTE functions. To understand the process, follow the steps.

Steps:

• Firstly, select cell C5.
• Then, write down the following formula.

• Press Enter to apply the formula.

• Afterward, drag the Fill Handle icon down the column.

3. Using Excel 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. To understand it clearly, follow the steps.

Steps:

• First of all, select cell C5.
• Subsequently, write down the following formula.

• Press Enter to apply the formula.

• Finally, drag the Fill Handle icon down the column.

4. Provide a New Time in Excel with MINUTE Function

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. To understand the example clearly, follow the steps.

Steps:

• In the beginning, select cell C5.
• Next, write down the following formula.

• Press Enter to apply the formula.

• Lastly, drag the Fill Handle icon down the column.

5. Insert MINUTE Function to Compute Difference in Minutes

You can also calculate the difference between start time and end time. By doing this, you will get the required minutes. In this article, we will show the difference in minutes using the MINUTE function. We take a dataset that contains some starting times and ending times.

To understand the example, follow the steps.

Steps:

• Firstly, select cell C5.
• Then, write down the following formula.

• Press Enter to apply the formula.

• Then, drag the Fill Handle icon down the column.

6. Embedding VBA Code to Get Minutes in Excel

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.

Steps:

• First, go to the Developer tab on the ribbon.
• Then, select the Visual Basic option from the Code group.

• It will open up the Visual Basic window.
• Then, go to the Insert tab at the top.
• After that, select the Module option.

• As a result, a Module code window will appear.
• Write down the following code.

Sub Minute_Function()
Dim i As Integer
For i = 5 To 12
Cells(i, 4).Value = Minute(Cells(i, 2))
Next i
End Sub

• Then, close the Visual Basic window.
• Then, go to the Developer tab on the ribbon.
• Select the Macros option from the Code group.

• Then, the Macro dialog box will appear.
• Select Minute_Function from the Macro name section.
• After that, click on Run.

• As a result, we will get the minute value from the time value. See the screenshot.

Sub Minute_Function()

Dim i As Integer

For i = 5 To 12

Cells(i, 4).Value = Minute(Cells(i, 2))

Next i

End Sub

Common Errors While Using MINUTE Function