Time: problems with Sum

[Mark]

Hi,

I am trying to add up Time values - problem is Sum returns 0.

Looking at the values, they appear to be text - here is a sample:

000:02:30
000:14:50
000:00:00

They are imported from somewhere - I guess I need to convert them into time
values first.

Any ideas?

 

[JE McGimpsey]

One way:

Select your cells. Choose Edit/Find

Find: 000
Replace with: 0