Results 1 to 5 of 5

Thread: need excel help please

  1. #1

    Question need excel help please



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi there
    I have a data which needs to be converted, here is the format
    Column A Column B
    57.9 57.90
    59.4 59.40
    1.0.3 60.30
    1.1.9 61.90
    1.2.9 62.90

    from the column A these need to be converted in seconds, 57.90 to 57.90, these are ok, there is no change for these's one's. need to change these
    1.0.3 means 1=1 min= 60 sec 0 = 0 sec .3=.30sec so it is 60.30
    similarly
    1.1.9 means 1 = 1 min = 60 sec, 1 = 1 sec, .9 = .90 sec so it is 61.90

    is there anyone who can help me with a formula to convert the column A data?
    please....
    I really need help.

    thanks

  2. #2
    Here is a very straight-forward way of doing it

    =IF(LEN(A1)-LEN(SUBSTITUTE(A1,".",""))<=1,A1,LEFT(A1,FIND(".",A1)-1)*60+MID(A1,FIND(".",A1)+1,99))

  3. #3
    thank you sooooooooooo much for your kind help.
    I really appreciate it.

    I forgot to mention about the other one, I mean for these 2.5.6 2.8.1 2.11.5
    I can't figure this out.

    I hope you will tell me how to do this, because when I use the above formula for 2 (i mean for these 2.5.6, 2.8.1, 2.11.5) , it shows me error result.

    hope to get reply from you

    thank you once again for your help


  4. #4
    2.5.6 returns 125.6 for me, what are you expecting?

  5. #5
    sorry, that was my mistake...
    I am really sorry about that.
    its working perfectly.

    thanks a lot....

Tags for this Thread

Posting Permissions

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