=LEFT(A21,FIND("m",A21)-1)*60+MID(A21,FIND("m",A21)+1,FIND("s",A21)-FIND("m"
,A21)-1)
--
HTH
Bob Phillips
"Dave" wrote in message
...
How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15
or
58.98. I've tried formatting the column next to the data "ss.00" but it
does
not work.
Any help would be appreciated.
|