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)
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 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.
0 to 59 (in number format)
|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.
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.
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.
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.
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
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.
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|
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.
- 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)