How to Add Time in Excel Over 24 Hours (4 ways)

I’ll explain to you how to add time in Excel over 24 hours in an efficient and easy way. We will use a sample dataset, where names and weekly hours are given.

Adding Time in Excel Over 24 Hours: 4 Simple Ways

Method 1: Adding Time in Excel Over 24 Hours Manually

We will see, how to add time over 24 hours manually in this method.
First, click on cell H5 and type the following formula.

=C5+D5+E5+F5+G5

Now, press the ENTER key.

After that, drag down to AutoFill.

Here, we can see, it is not the result we wanted. Because Excel can not count time over 24 hours. That’s why we need to format the cells.
At this point, left-click the mouse button and select Format Cells.

A new dialogue box will pop up, from here, we will select Custom and [h]:mm. Then click OK. Here, we want our time count in Hour and Minute format not in Hours:minutes:seconds. That’s why we didn’t select hh:mm:ss.

Finally, we got our results. It looks like the image below.

Method 2: Adding Time in Excel Over 24 Hours Using Sum Function

This time we will add time using the SUM function.
First, click on cell H5 and type the following formula.

=SUM(C5:G5)

Now, press the Enter key.

After that, drag down to AutoFill.

we can see, it is not the result we wanted. Because Excel can not count time over 24 hours. That’s why we need to format the cells.
At this point, left-click the mouse button and select Format Cells.

A new dialogue box will pop up, from here, we will select Custom and [h]:mm. Then click OK. Here, we want our time count in Hour and Minute format not in Hours: minutes: seconds. That’s why we didn’t select hh:mm:ss.

Finally, we got our results. It looks like the image below.

Method 3: Adding Time in Excel Over 24 Hours Using AutoSum Function

Now, we will use AutoSum from the Formulas ribbon.
First, click on cell H5 and go to the Formulas Ribbon, then select Sum from the AutoSum section.

Now, our worksheet will look like the following image.

Press the ENTER key now.

Drag down to AutoFill.

We can see, it is not the result we wanted. Because Excel can not count time over 24 hours. That’s why we need to format the cells.
At this point, left-click the mouse button and select Format Cells.

A new dialogue box will pop up, from here, we will select Custom and [h]:mm. Then click OK. Here, we want our time count in Hour and Minute format not in Hours:minutes: seconds. That’s why we didn’t select hh:mm:ss.

Finally, we got our result. It looks like the image below.

Method 4: Adding Time in Excel Over 24 Hours Using TEXT & SUM Function Together

Here, we will see how to use the SUM and TEXT functions together to add time over 24 hours.
First, click on cell H5 and type the following formula.

=TEXT(SUM(C5:G5),"[h]:mm")

Now, press the ENTER key.

Finally, drag down to AutoFill for the rest of the series.
Simple.

Practice Section

The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, I’ve attached a practice workbook where you may practice these methods.

Download Practice Workbook

Adding-Time-Over-24 Hour.xlsx

Conclusion

There are four different ways to add time in Excel over 24 hours. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.