SUM(...)
How to sum time in excel.
Used Functions
Category: Math and trigonometry
Adds its arguments
Syntax
SUM(number1,[number2],...)
Category: Math and trigonometry
Adds its arguments
SUM(number1,[number2],...)
Practice SUM Formula at Sheetzoom
SUM formula at Microsoft help
0
We will use the SUM() function but the cells need to be formatted as time i.e. [h]:mm:ss;@ in order to get the desired result. The SUM() function only takes range as an argument.