Hello,

I get following data with leading space infront of the values. I tried
pretty much everything suggested in news group, anywhere from formatting the
cells to removing space and adding. All I get is 00:00:00 in the result cell.
However, if I manually remove space infront of each value the sum works fine.
Removing space manually is not very productive. I would appreciate if anyone
encountered similar problems before and had resolved it.

02:47:19
00:00:01
00:29:19
00:26:17
0:00

Regards,

Dan Rao