convert 0.00.0 (min's.seconds.tenths of a second) to seconds only

[aneer miss]

Hi

I've looked everywhere but can't seem to find anything similar, as it's not really a convert time to seconds problem - its a convert time to time problem???

Could someone please help with the above conversion?

As an example 2.08.3 should be converted to 128.3 seconds.

I'm using Excel 2007.

Thanks in advance.

 

[Peter_SSs]

I'm assuming that 2.08.03 is a text value, If so, try this

=LEFT(A1,FIND(".",A1))*60+REPLACE(A1,1,FIND(".",A1),"")

 

[pgc01]

Hi

Another option:

=0+TEXT(SUBSTITUTE(A1,".",":",1),"")

 

[Peter_SSs]

Hi

Another option:

=0+TEXT(SUBSTITUTE(A1,".",":",1),"")

For the sample data/result given that might need to be
=0+TEXT(SUBSTITUTE(A1,".",":",1),".0")

 

[pgc01]

For the sample data/result given that might need to be
=0+TEXT(SUBSTITUTE(A1,".",":",1),".0")

Thank you Peter. I didn't read with attention and thought that only the seconds were needed.

 

[aneer miss]

beautiful...thank you gents