Time Format

[Donald B]

0:00:01:48
0:00:02:14
0:00:03:03
0:00:03:38
0:00:01:53
0:00:03:07
0:00:05:54

These numbers are imported as a text format. I tried to format cells as
time and custom but no luck. I also tried the 'RIGHT" function. I want to add
these up but been unsuccessful.
Hope I provided enough information.

TIA
Don

 

[Sandy Mann]

Try:

=--RIGHT(A1,LEN(A1)-2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk