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

**Table of Contents**hide

## 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+D5`

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