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?
I really need help.

thanks

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. 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. 2.5.6 returns 125.6 for me, what are you expecting?

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

thanks a lot....