Time Format
 

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

Time Format
 

Try:

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Donald B" wrote in message
...
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