Excel: Add hours correctly
Add hours in Excel to get curious results. The reason: When adding up, Excel cannot process all values over "24 hours". With a little change it works anyway.
Add hours in Excel - that's how it's done
- First, make sure that your cell data is also formatted as "hours": To do this, select all the data and right-click on it.
- Open "Format cells" in the context menu and select the "Custom" category. The following formatting must be present here: "hh: mm" or "hh: mm: ss".
- Then right-click on the cell in your workbook that should display the total.
- Select "Format cells" again and change the formatting in the "User-defined" category to "[hh]: mm".
- The brackets prevent Excel from automatically expressing the value in days after 24 hours and no longer displaying them. Confirm your entry with "Ok" and the total is automatically recalculated.
More tips and tricks for calculating with Excel can be found here.