Excel 97

  • Thread starter Thread starter EADesktop
  • Start date Start date
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
 
You can convert the text to time with the following formula :-

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

Format as HH:MM:S
 
Back
Top