Adding time 00:00:00 in a csv file

[equal]

I have a comma separated value file with a column of clock values in hrs minutes and second. Ex 00:00:00.
How can I add all the values in the column to get the total time?

[oweng]

When importing the CSV make sure you check the Detect special numbers on the import dialog:

This will ensure the times are recognised as time, rather than text. The imported column of times can then be summed as usual, but the format of the summing cell, needs to be set to [HH]:MM:SS:

The result should be:

[equal]

thanks you! that fixed it!

[mariosv]

Please mark the answer as correct, clicking on (V)