Sabrina Ayon
We can put time values together to generate a cumulative time value. Since time values are only a decimal extension of the date serial numbering scheme. We might want to add a specific number of minutes to an existing time value in various instances. In this article, we will utilize to add minutes to time in excel.
Download Practice Workbook
You can download the workbook and practice with them.
5 Easy Ways to Add Minutes to Time Quickly In Excel
Let’s say we need to add minutes to time. Excel makes it easy to add a given number of minutes to a time. Now, we will go through some easy ways to add minutes to time in excel.
1. Use Formula to Add Minutes to Time in Excel
In excel, times are expressed as fractional values of 24 hours. We can add minutes divided by 1440. An hour is 1/24. So, a minute is 1/(24*60) = 1/1440.
In the following dataset, column B contains the time and column C contains the decimal value for minutes. After adding minutes to time, the results will show in column D and column E will display the formula. Now, let’s have a look at how to add the minutes using the formula.
STEPS:
- First, select the cell E7 which is in the result column.
- After that, write down the formula. The generic formula to add minutes to times is:
=time+(minutes/1440)In our dataset, we will take cell B7 and cell C7 which contain sequentially time and minutes. So our formula will be:
=B7+(C7/1440)Which we can see in the formula column.
- Then, press Enter.
This will add the minutes to the times shown in the picture below. Make sure results are formatted as Time.
Related Content: How to Calculate Hours and Minutes for Payroll Excel (7 Easy Ways)
2. Add Minutes to Time Using Format Cells Feature
Likewise the previous method, we are using the same dataset and also use the same formula. But the problem is if we don’t change the result column format to time, we won’t get the desired outcome. Instead of changing the format manually, we can customize the format by using the Format Cells feature. For this, we need to follow some simple steps.
STEPS:
- Firstly, we select the range E7:E10.
- Then, right-click on the mouse and select Format Cells.
- This will open the Format Cells window.
- Next, from the window go to time and select as you want the result. Here, let’s select the third one which will show only the hour and minutes.
- After selecting the format click on the OK button.
- Or we can also customize the format as per our requirements. For this just go to the Custom option then select the required format. After that click OK.
- As we select the hour and minute format, our resulting time shows in that format after adding the minutes to time.
Read More: Add 15 Minutes to Time in Excel (4 Easy Methods)
3. Apply TIME Function to Add Minutes to Time in Excel
We won’t have to remember the formula for converting decimal minutes to an excel time if we use the TIME function. When values surpass 24 hours, the TIME function will “roll over” and return to zero. Our dataset is the same as before, now we are going to use the TIME function to add minutes to time by following some simple steps.
STEPS:
- In the beginning, we must select the cell we want to use the formula. So, we are selecting cell E7.
- After that just type the formula. The generic formula for TIME function for adding minutes to time is:
=time+TIME(0,minutes,0)Following the above formula, we are going to type the formula:
=B7+TIME(0,C7,0)As our time and minutes are in different cells already.
- Finally, press Enter. And we can see the minutes are added with the time.
Read More: How to Add Time in Excel Over 24 Hours (4 ways)
Similar Readings
- How to Sum Time in Excel (9 Suitable Methods)
- Calculate Hours Between Two Times in Excel (6 Methods)
- How to Calculate Total Hours in Excel (9 Easy Methods)
- Add Minutes and Seconds in Excel (3 Easy Methods)
- How to Add Hours, Minutes, and Seconds in Excel
4. Insert NOW Function to Add minutes to the Current Time
If we want to see what the time will be from now after adding different minutes. We can also have a look at the current time after adding minutes by using the NOW function in excel. This function has no arguments.
STEPS:
- To add minutes to the current time, in the beginning, just write down the formula in the selected cell.
=NOW()+C7/1440- Finally, we can see the time after adding minutes in the result column. And remember that, the NOW function will continuously update the time.
Read More: How to Insert Current Date and Time in Excel (5 Easy Methods)
5. Add up Minutes with SUM Function
If we want to add the total time we can do it by using the SUM function. We use the same dataset to add up the minutes.
STEPS:
- First, as we want to see, the add-up minutes result in cell E11, so select cell E11.
- After that, just select the cell and type the formula:
=SUM(E7:E10)- Now, we will get our results and the formula is also shown in the picture below.
Read More: Adding Hours and Minutes in Excel (4 Suitable Methods)
Things to Remember
- In the TIME function, the #NUM! error occurs if the given hours are less than 0.
- The #VALUE! error occurs when any of the given inputs are non-numeric.
Conclusion
By following those simple methods you can easily add minutes to time in excel. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!
Related Articles
- How to Add Date and Time in Excel (4 Easy Methods)
- Excel formula to calculate hours worked & overtime [with template]
- How to Add 1 Hour to Time in Excel (7 Examples)
- Calculate Difference Between Two Dates and Times in Excel
- How to Add Time to Date in Excel (4 Useful Methods)
- Add 8 Hours to Time in Excel (4 Suitable Ways)
- How to Add Time in Excel Automatically (5 Easy Ways)
