General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Is there any way to change a column of times done like this 1.34.56 into 94.56 ? obviously via a formula..tia.
Show More
If your time is in CELL A1
Format the cell you want the answer in as number format and paste this into that cell
=HOUR(A1)*60+MINUTE(A1)&"."&SECOND(A1)
Format the cell you want the answer in as number format and paste this into that cell
=HOUR(A1)*60+MINUTE(A1)&"."&SECOND(A1)
i have cells from c2 to c47 all with times like this 1.12.32 ....they have just been entered as numbers no formatting. now i just want them converted ...ie ..in the case above 1.12.32 becomes 72.32 secs.
If you need to do calculations on it
Copy the Cell and go to paste special and click paste values
Copy the Cell and go to paste special and click paste values
If it is all ready text or number format (CELL C2)
In Cell D2 enter this formula and fill down as needed
=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,2)
If you want the answers in C Column
Copy results from D column Select CELL C2 then Paste special, Paste Values
Then clear D column
In Cell D2 enter this formula and fill down as needed
=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,2)
If you want the answers in C Column
Copy results from D column Select CELL C2 then Paste special, Paste Values
Then clear D column
OOps change
=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,2)
To
=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,3)
=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,2)
To
=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,3)
compound thank you very much...it works...apart from the races that were under a minute....thanks again....a big help!
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539