How to add time in Excel (step-by-step method)

August 5, 2022
406 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Time is the most important element and when it comes to business, it is necessary to make it official by adding it on excel add time option.

With excel add time, you can add any given time using the formula mentioned below. Be it less than 24 hours or more than 24 hours you can add time easily.

Why you need to Add Time on Excel?

You might be thinking that why you you need to add time on Excel. This article will show you that when you have time for multiple tasks then you need to keep a proper follow-up of your time schedule. At that time, WPS Excel Add time take care of your time.

You can add time of multiple tasks using WPS Excel or spreadsheet. WPS office has made it so easy by giving the option of excel add time. You just need to add the insert the task timings, insert the formula then press okay and you are good to go.

How to add time on excel (less than 24-hours)

If you want to add time that is less than 24 hours the formula is quite simple and time can be added in simply two steps.

Let's take an example. You are required to do two tasks and you want to estimate the total time that will be taken by these two tasks altogether. First task takes 5 hours and 30 minutes, while the second task takes 8 hours and 45 minutes. You merely need to take two cells and add up the time using simple 'SUM formula'

Step 1

Enter the time 5 hours and 30 minutes of task 1 in cell 'B2' and time 8 hours and 45 minutes of task 2 in the cell 'B3'.

Step 2

In the next step add B2+B3 in the cell B4, and then enter. You will get the desired result.

This summation is pretty easy, but the problem arises when you need to add the time that is of more than 24 hours.

How to add time on excel (More than 24-hours)

Now lets take another example where you have to add time which will be more than 24 hours.

You are required to do two tasks and you want to estimate the total time that will be taken by these two tasks altogether. The First task takes 12 hours and 45 minutes, while the second task takes 15 hours and 30 minutes.

Step 1

Enter the time of task 1 in cell 'B2'and time of task two in the cell 'B3'.

Step 2

In the next step add B2+B3 in the cell B4, and then enter. You will get 4:15

But 4:15 is not the appropriate answer. It should be 28 hours and 15 minutes logically.

But let's get to next step to see how it happens using excel add time.

Step 3

Click on the cell B4, to get the required result.

(See the next step carefully)

Step 4

On the top bar, go to home, then in the cells group, click on format and right after that click on format cells.

Step 5

Then in the format cells, you will see an option of  Custom  in the  Category  list.

Step 6

Then at the top of list of formats, go to  Type  box, and type  [h]:mm;@  and the click OK.

(Make sure you use the formula correctly. See it again,  [h]:mm;@

The brackets around  h , then a colon followed by double m, then a  semicolon and then  @  and you are done)

You will get the answer: 28 hours and 15 minutes.

This format will be available in the Type list, the next time you wanna see it.

Have you learned about excel add time? If you want to know more about Word and Excel (2016/2019/mac/online) features, you can follow WPS Academy to learn.

Download WPS Office to edit your word documents, make databases on excel sheets, create presentations on PowerPoint without any fee. Download Now! Save your time and enjoy hassle-free work experience.