Excel: Calculating with times - these formulas are necessary
In Excel, you can format the contents of your cells as you wish. For example, you can specify that it is a date or a time. If you want to add or remove a specific time to the time, then this is also easily possible in Excel.
How to calculate with times in ExcelHave you created a table in Excel and want to have certain information calculated, the application's functions can help you. In doing so, it is quite possible to also calculate with dates or a time. You do not have to use any specific functions, because subtraction and addition also recognize the time format.
- If there are times in both cells that you want to add together, you can connect them with a "+". To do this, enter "=A1+A2." If there is the time "6:45" in cell A1 and "9:30" in cell A2, then you get as a result "16:15".
- Alternatively, you can also apply the SUM function to the cells.
- However, if your calculation exceeds the 24h limit, then you still need to format the cell of the result. If A1 says "12:45" and A2 says "15:30", then you will get the result "4:15" with simple addition. Click on the result and go to the top of the bar on "Format" and then "Format cells."
- Now select "Custom". At "Type" you can now specify the clock format of your choice. Confirm with "Ok" to apply it to the cell.