Excel 97

E

EADesktop

I have a list of timecodes, examples,
ESD1.2
ESD12.3.2
ESD12.4.12
ESD4.4.2
ESD13.1.1
ESD2.2.6
ESD13.1.2
ESD4.3.3
ESD13.2
ESD14.2.1
ESD2.1.3
ESD4.3.2
ESD2.2
ESD4.4.4

they are formatted as General
Any ideas how to list them in order of number
 
B

BrianB

You can convert the text to time with the following formula :-

=TIMEVALUE(SUBSTITUTE(RIGHT(A1,LEN(A1)-3),".",":"))

Format as HH:MM:S
 
Top