Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

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

  1. #1
    New Member
    Join Date
    Nov 2010
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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.

  2. #2
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,414
    Post Thanks / Like
    Mentioned
    79 Post(s)
    Tagged
    16 Thread(s)

    Default 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),"")
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  3. #3
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,517
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    2 Thread(s)

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

    Hi

    Another option:

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

    To understand recursion, you must understand recursion.

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    39,414
    Post Thanks / Like
    Mentioned
    79 Post(s)
    Tagged
    16 Thread(s)

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

    Quote Originally Posted by pgc01 View Post
    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")
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

  5. #5
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,517
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    2 Thread(s)

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

    Quote Originally Posted by Peter_SSs View Post
    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.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  6. #6
    New Member
    Join Date
    Nov 2010
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    beautiful...thank you gents

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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