HOME > Office programs > Excel: Adding Times - It's That Easy

Excel: Adding times - it's that easy

Not infrequently, it is advantageous if individual times within a table can be added together. Especially in schedules, the addition of different times often plays an important role. With Excel, this can be done automatically.

How to add times in Excel

An addition of time works basically similar to the calculation of conventional numbers. Only the formatting is important.
  1. First start Excel and open the document in which clock times are to be calculated.
  2. Now select all cells in which clock times are located and make a right-click in the selected area.
  3. From the context menu, now select "Format cells".
  4. Switch to the "Numbers" tab and navigate to "Custom".
  5. For "Type", now enter [hh]:mm and confirm with "OK".

Excel: Add times - now it is calculated

  1. To now calculate with the just formatted times, you must apply a formula.
  2. To do this, click in an empty cell and use the command: =SUM(cell1+cell2).
  3. Tauschen Sie die Zellen mit dem entsprechenden Index der einzelnen Summanden.
  4. Wenn Sie nun [Enter] drücken, wird in der Zelle automatisch die Berechnung durchgeführt.
  5. Über das gleiche Prinzip können Sie auch andere Rechnungen durchführen. Achten Sie jedoch darauf, dass dies mit Zeiten schnell problematisch werden kann.
  6. Sie können übrigens auch mehrere Zellen oder Bereiche gleichzeitig berechnen lassen, ohne jedes Mal eine neue Addition durchführen zu müssen.

By O'Meara

Using Tik Tok on your PC - these are the options you have :: Playing Xbox One in pairs - this is how it works