I get data in a .csv file. Once I import data I formatt the column with
Custom (hh:mm:ss) and sum the values.

Dan Rao

"Sloth" wrote:

How are you adding them? How are you inputting the times? Is this imported
data?

If it is imported, you would need to use Data-Text to Columns and then cut
and paste back to the first row.

"Dan" wrote:

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