Excel – Adding of time in Excel gives a strange answer

microsoft excel

I tried to add the following times:

4:28:31

and

17:51:13

and got:

46:19:44

using simply =firstCell+secondcell

all are in [h]:mm:ss format.

What could be the reason why the answer is wrong?

Best Answer

If you format your cells in hh:mm:ss you get the correct result:

enter image description here

Related Question