Copy last 3 characters and rearrange the range

[shronk]

Hi,

I have a exported table with race results.
Like this:

Please Login or Register  to view this content.

Now I would need the general results for my general classification.
I've tried to break the general time row into two parts the following way:

Please Login or Register  to view this content.

Now I've got negative numbers. How can I change those numbers into positives and then sort the table in an ascending order?

Thanks for your help!

[ARGK]

Hi
Excel treats any number in brackets as a negative number.
Hope this helps.
Tony

[JOHN H. DAVIS]

Maybe:??

Please Login or Register  to view this content.