You need to add a new column with a formula to do the conversion. If
you data is in cell A1 use this formula in cell B1
=(60*LEFT(A1,FIND("m",A1)-1))+MID(A1,FIND("
",A1)+1,(FIND("s",A1)-FIND(" ",A1))-1)
The formula extracts the 1 minutes and multiplies by 60 then extracts
the 1.40 and adds it to the value 60.
The formula works by loking for the character m and extracts the
characters to the left of the "m". then the formula extracts the
characters between the 1st blank character and the "s" character.
--
joel
------------------------------------------------------------------------
joel's Profile:
http://www.thecodecage.com/forumz/member.php?u=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=206223
http://www.thecodecage.com/forumz