Musiha Mahfuza Mukta
If you are looking for adding Hours and Minutes in Excel then you have come to the right place. Here, in this article I will demonstrate how to use Excel for adding Hours and Minutes.
Download Practice Workbook
You can download the practice workbook from here:
4 Methods for Adding Hours and Minutes in Excel
Here. I will explain 4 easy methods for adding Hours and Minutes in Excel. For your better understanding, I’m going to use the following dataset. Which contains 3 columns. Those are Employee Name, Working Time, and Extra Time.
1. Applying SUM Function for Adding Hours and Minutes in Excel
You can apply the SUM function for adding Hours and Minutes in Excel. In addition, the SUM function will work in time format. The steps are given below.
Steps:
- Firstly, you have to select a different cell E5 where you want to see the result.
- Secondly, you should use the corresponding formula in the E5 cell.
=SUM(C5:D5)Here, the SUM function will sum up all the times. And, C5:D5 denotes the data range which to add.
- Subsequently, you must press ENTER to get the result.
As you can see, the result is 8:00 which should be 30:00. Basically, the SUM function returns the result as a time of 24 hours format.
- Now, you can drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells E6:E10.
Finally, you will get the following result. If your added time won’t cross 24 hours then you don’t need to follow further steps.
But, as I have more than 24 hours, I have to modify the result.
- Now, select the output E5:E10.
- Then, you need to press the CTRL+1 keys to open the Format Cells dialog box directly.
Also, you can use the Context Menu Bar or the Custom Ribbon to go to the Format Cells command. In the case of using the Context Menu Bar, select the data range >> Right-Click on the data >> choose the Format Cells option.
In the case of using Custom Ribbon, select the data range >> from the Home tab >> go to the Format feature >> choose the Format Cells command.
After that, a dialog box named Format Cells will appear.
- Now, from that dialog box, you have to make sure that you are on the Number command.
- Then, go to the Custom option.
- After that, you should type [h]:mm in the Type: box.
- Finally, you have to press OK to get the changes.
Lastly, you will see the added Hours and Minutes.
Read More: How to Add Hours, Minutes, and Seconds in Excel
2. Use of TEXT Function with SUM Function
You can apply the TEXT function with the SUM function for adding Hours and Minutes in Excel. The steps are given below.
Steps:
- Firstly, you have to select a different cell E5 where you want to see the result.
- Secondly, you should use the corresponding formula in the E5 cell.
=TEXT(SUM(C5:D5),"[h]:mm")
Formula Breakdown
- Here, the SUM function will sum up all the times of the given range.
- SUM(C5:D5)—> turns 8:00.
- Then, the TEXT function will return a value in text with a given format.
- In addition, “[h]:mm” denotes the format. Which will convert the time into added hours.
- TEXT(8:00,”[h]:mm”)—> becomes 32:00.
- Now, you must press ENTER to get the result.
- Then, you can drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells E6:E10.
Finally, you will see the following added hours and minutes.
Read More: How to Add Hours to Time in Excel (8 Quick Ways)
Similar Readings
- Add 15 Minutes to Time in Excel (4 Easy Methods)
- Add Milliseconds to Time in Excel (with Quick Steps)
3. Employing Generic Formula for Adding Hours and Minutes in Excel
You can apply a generic formula for adding Hours and Minutes in Excel. In addition, this formula will work in time format. The steps are given below.
Steps:
- Firstly, you have to select a different cell E5 where you want to see the result.
- Secondly, you should use the corresponding formula in the E5 cell.
=C5+D5In this formula, I have summed up two cell values using Plus (+) sign.
- Thirdly, press ENTER.
Here, you can see the result is 1:00 which should be 25:00. This is because the formula counts the cell values as time.
- Now, you may double click on the Fill Handle icon to AutoFill the corresponding data in the rest of the cells E6:E10.
As you can see, the formula returns the result as a time of 24 hours format. If your added time won’t cross 24 hours then you don’t need to follow further steps.
- Now, select the output E5:E10.
- Then, you need to press the CTRL+1 keys to open the Format Cells dialog box directly.
Also, you can use the Context Menu Bar or the Custom Ribbon to go to the Format Cells command. In the case of using the Context Menu Bar, select the data range >> Right-Click on the data >> choose the Format Cells option.
In the case of using Custom Ribbon, select the data range >> from the Home tab >> go to the Format feature >> choose the Format Cells command.
At this time, a dialog box named Format Cells will appear.
- Now, from that dialog box, you have to make sure that you are on the Number command.
- Then, go to the Custom option.
- After that, you should type [h]:mm in the Type: box. Here, you can see the sample immediately in the Sample box.
- Finally, you have to press OK to get the changes.
Lastly, you will get all the added hours and minutes.
Read More: How to Add Minutes to Time in Excel (3 Quick Methods)
4. Applying TIME, HOUR & MINUTE Functions
You can apply the TIME, HOUR, and MINUTE functions for adding Hours and Minutes in Excel. In addition, this TIME function will return the result in time format. Furthermore, I will add 1 hour 45 minutes throughout this method. The steps are given below.
Steps:
- Firstly, you have to select a different cell E5 where you want to see the result.
- Secondly, you should use the corresponding formula in the E5 cell.
=TIME(HOUR(C5)+1,MINUTE(C5)+45,0)
Formula Breakdown
- Firstly, the MINUTE function will extract only the minutes from a given time.
- MINUTE(C5) —> becomes 30.
- Secondly, the HOUR function will extract only the hours from a given time.
- HOUR(C5) —> turns 8.
- Thirdly, the TIME function will convert a number into time.
- TIME(8+1,30+45,0) —> gives 10:15.
- At this time, press ENTER to get the result.
- Now, you may double-click on the Fill Handle icon to AutoFill the corresponding data in the rest of the cells E6:E10.
As you can see, the result is in 24 hours time format.
Read More: How to Add Time in Excel Automatically (5 Easy Ways)
💬 Things to Remember
- Here, method 2 (TEXT) will return the exact result. This means you will get the added hours not the added time.
- In the case of other methods, you don’t need to do formatting when the added hours will be less than 24 hours. If the added values cross 24 hours then you must do formatting.
Practice Section
Now, you can practice the explained method by yourself.
Conclusion
I hope you found this article helpful. Here, I have explained 4 suitable methods for Adding Hours and Minutes in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
