Question

Excel: add times - this is how it works

Answer 1

How to add times in Excel
1st step:
2nd step:
3rd step:
quick start Guide

---

Do you have an Excel list of times and would like to add these up to a total? We explain how to do it..

Microsoft Excel has numerous functions and formulas to make your work easier. Including one that you can use to add up times. Simply follow our step-by-step instructions.

How to add times in Excel

Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

Open Excel and enter the times you want. Now write in the cell where you want the result to be = x + y . For x and y, insert the cells that contain the values ​​to be added. You can add as many cells as you want.

2nd step:

If you now have times that exceed 24 hours , the result looks a bit strange at first. You can change this by using the cells with the times mark and the tab " Start " in " cells " to " Format " button and from the menu " Format Cells ... " option.

3rd step:

Now enter the following for " Type " and then click " OK ": [h] whole hours [h]: mm hours and minutes [h]: mm: ss hours, minutes and seconds [m] whole minutes [m]: ss minutes and seconds [s] whole seconds

quick start Guide

1. Enter the times you want and write = x + y in the cell where you want the result to be. For x and y enter the cells in which the times are.
2. If the times you specify exceed 24 hours , you will need to format the cells . To do this, click on " Format " and " Format cells ... " in the " Start " tab .
3. Enter the following for " Type ": - [h] whole hours

1. - [h]: mm hours and minutes

1. - [h]: mm: ss hours, minutes and seconds

1. - [m] whole minutes

1. - [m]: ss minutes and seconds

1. - [s] whole seconds

---