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)**

**Table of Contents**hide

## 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.

### 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.

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.

### 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.

### 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.

### 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.

## 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

**How to use HOUR Function in Excel (5 Easy Examples)****How to Use DAY Function in Excel (With 3 Examples)****How to Use the Excel DAYS Function with a Practical Example****How to Use NETWORKDAYS Function in Excel (3 Suitable Examples)****How to Use TODAY Function in Excel (6 Easy Examples)****How to Use WORKDAY Function in Excel (5 Examples)**