1. ## need excel help please

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  Reply With Quote

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))  Reply With Quote

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  Reply With Quote

4. 2.5.6 returns 125.6 for me, what are you expecting?  Reply With Quote

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

thanks a lot....   Reply With Quote

excel, formula 