hi there
I have a data which needs to be converted, here is the format
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
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