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