Time Format

D

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
 
S

Sandy Mann

Try:

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

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top