Times: How to convert into Seconds and Hundreths

[chrisj2812]

Hi,

I'm running a webscraper which returns times as follows: Does anyone know how I can simply convert these to seconds and hundredths. It seems really simple but I can't figure it out!

So for 1m 42.09, I'd like to just see 102.09

Many Thanks

Chris

1m 42.09 59.69 58.42 1m 27.92 1m 41.7 2m 23.75 58.22

 

[offthelip]

try this:
=IFERROR(60*LEFT(A3,(FIND("m",A3))-1)+MID(A3,(FIND("m",A3))+2,1000),A3)

 

[Bo_Ry]

Please try
=IFERROR(--A1,SUBSTITUTE(A1,"m ",":")*86400)

 

[Tetra201]

Try using the following formula and formatting the cell as

[s].00

=--("0:"&SUBSTITUTE(A1,"m",":"))

 

[chrisj2812]

Awesome work. Thank you so much for your time and knowledge!