Need help; can't SUM hh:mm:ss

**ludi_golub** · 05-14-2013, 11:46 AM

hey, users of forum i need help regarding auto sum here is example:

00:02:06
00:00:23
00:01:53
00:00:18

Now the problem is excel will sum this right if in dialog of sum i enter =SUM(D8+D9+D10+D12) but i wasting time replacing ; with +

So is there easier method to sum this.

Thanks for help.

**ChemistB** · 05-14-2013, 11:57 AM

Your data is being identified as text and excel won't sum text. When you use the plus sign, that forces Excel to recognize it as numbers.

Try selecting the column of times and going to the Data Tab> Text to Column> Finish
Then try sum.

**ludi_golub** · 05-14-2013, 12:15 PM

wow, Thanks for help. This saved me lot of nerves.

Enjoy your day.

**Lemice** · 05-14-2013, 12:15 PM

Hello and welcome to the forum,

Apart from the solution from ChemistB, you can try this Array formula
=SUM($D$8:$D$12+0)

When you confirm it, you will need to hold Ctrl-Shift and hit Enter. If you see the formula being wrapped inside a { } then you did it right.