How to Add Minutes to Time in Excel (5 Easy Ways)

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.

Use Formula to Add Minutes to time

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.

Use Formula to Add Minutes to time in excel

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.

Add Minutes to Time Using Format Cells Feature

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

Add Minutes to Time Using Format Cells Feature

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

Add Minutes to Time Using Format Cells Feature

  • As we select the hour and minute format, our resulting time shows in that format after adding the minutes to time.

Add Minutes to Time Using Format Cells Feature

Related Content: How to Calculate Total Hours in Excel (9 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.

Apply TIME Function to Add Minutes to Time in Excel

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

Apply TIME Function to Add Minutes to Time in Excel


Similar Readings:


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.

Related Content: How to Calculate Difference Between Two Dates and Times in Excel


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.


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

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Excel and VBA Content Developer. I'm a student of United International University and my program is Computer Science and Engineering. I love working with computers and solving problems. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo