General Betting
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.
sort by:
Show
per page
Replies: 7
|
By:
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) |
|
By:
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.
|
|
By:
If you need to do calculations on it
Copy the Cell and go to paste special and click paste values |
|
By:
thanks cm but i'm just stuck.
|
|
By:
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 |
|
By:
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) |
|
By:
compound thank you very much...it works...apart from the races that were under a minute....thanks again....a big help!
|