Thanks:  0
Likes:  0

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

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

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

As an example 2.08.3 should be converted to 128.3 seconds.

I'm using Excel 2007.

2. ## Re: convert 0.00.0 (min's.seconds.tenths of a second) to seconds only

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),"")

3. ## Re: convert 0.00.0 (min's.seconds.tenths of a second) to seconds only

Hi

Another option:

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

4. ## Re: convert 0.00.0 (min's.seconds.tenths of a second) to seconds only

Originally Posted by pgc01
Hi

Another option:

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

5. ## Re: convert 0.00.0 (min's.seconds.tenths of a second) to seconds only

Originally Posted by Peter_SSs
For the sample data/result given that might need to be
=0+TEXT(SUBSTITUTE(A1,".",":",1),"[s].0")
Thank you Peter. I didn't read with attention and thought that only the seconds were needed.

6. ## Re: convert 0.00.0 (min's.seconds.tenths of a second) to seconds only

beautiful...thank you gents

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•