# How to Add Minutes to Time Quickly In Excel: 5 Easy Ways

### Method 1 – Use Formula to Add Minutes to Time in Excel

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.

STEPS:

• Select cell E7 which is in the result column.
• Write down the formula to add minutes to times:
`=B7+(C7/1440)`
• Press Enter.

This will add the minutes to the times shown in the picture below. Make sure results are formatted as Time.

### Method 2 – Add Minutes to Time Using Format Cells Feature

STEPS:

• Select the range E7:E10.
• Right-click and select Format Cells. This will open the Format Cells window.

• Go to Time and select a format. Here, let’s select the third one which will show only the hour and minutes.
• Click on the OK button.

• We can also customize the format. Go to the Custom option and select a format, then click OK.

• Our resulting time shows in that format after adding the minutes to time.

### Method 3 – Apply TIME Function to Add Minutes to Time in Excel

STEPS:

• Select cell E7.

• Use the formula:
`=B7+TIME(0,C7,0)`

This converts the number into a time format and the addition is converted back into time.

• Press Enter.

### Method 4 – Insert NOW Function to Add Minutes to the Current Time

STEPS:

• Write down the formula in the selected cell:
`=NOW()+C7/1440`
• Finally, we can see the time after adding minutes in the result column. The NOW function will continuously update.
• Note that this completely ignores the starting times from the B column.

### Method 5 – Add up Minutes with SUM Function

STEPS:

• Create a new cell E11 for the sum and select it.
• Type the formula:
`=SUM(E7:E10)`
• Press Enter to get the sum of all times in the E7:E10 range.

## Things to Remember

• In the TIME function, the #NUM! error occurs if the given hours are lower than 0.
• The #VALUE! error occurs when any of the given inputs are non-numeric.

## Related Articles

<< Go Back to Add Time in Excel | Calculate Time | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF