I'm not sure why you are getting an error. Maybe there is a blank
characters at the beginning or end of the string or your data isn't in
cell a1.


I modified the function to handle the case where there are no minutes

=IF(ISERR(FIND("m",A1)),LEFT(A1,LEN(A1)-1),(60*LEFT(A1,FIND("m",A1)-1))+MID(A1,FIND("
",A1)+1,(FIND("s",A1)-FIND(" ",A1))-1))


--
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