Great Thanks!



"Don Guillett" wrote:


try
to get 16:30
=TEXT(LEFT(D2,FIND("m",D2)-1)&":"&MID(D2,FIND(" ",D2),FIND("s",D2)-FIND("
",D2)),"hh:mm")
to get 16.5
=LEFT(D2,FIND("m",D2)-1)&TEXT(MID(D2,FIND(" ",D2),FIND("s",D2)-FIND("
",D2))/60,".#")
--
Don Guillett
SalesAid Software

"Tim" wrote in message
...
how can i do this but with two numbers

Eg, 16m 30s

This is 16 minutes 30 seconds.

and if you know this, how can i then turn this to read a a decimal, ie,
change 16m 4s to read 16.5

Tim


"Domenic" wrote:

Try...

=LOOKUP(9.99999999999999E+307,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

....where A1 contains your alpha-numeric string.

Hope this helps!

In article ,
"Old Tone" <Old wrote:

How do I extract decimal numbers from alphanumeric strings to perform
calculations on the number, eg 25.1 km or 100 m.