New Posts For Thread: Excel Help!https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-helpIs there any way to change a column of times done like this 1.34.56 into 94.56 ? obviously via a formula..tia.compound thank you very much...it works...apart from the races that were under a minute....thanks again....a big help!https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075214#421075214compound thank you very much...it works...apart from the races that were under a minute....thanks again....a big help!Fri, 09 Apr 2010 21:50:50 -0500OOps change=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,2)To=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,3)https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075210#421075210OOps change=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,2)To=LEFT(C2,1)*60+MID(C2,3,2)&RIGHT(C2,3)Fri, 09 Apr 2010 21:36:40 -0500If 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 ColumnCopy results from D column Select CELL C2 then Paste special, Paste Valueshttps://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075206#421075206If 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 ColumnCopy results from D column Select CELL C2 then Paste special, Paste ValuesFri, 09 Apr 2010 21:31:13 -0500thanks cm but i'm just stuck.https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075202#421075202thanks cm but i'm just stuck.Fri, 09 Apr 2010 21:20:29 -0500If you need to do calculations on itCopy the Cell and go to paste special and click paste valueshttps://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075198#421075198If you need to do calculations on itCopy the Cell and go to paste special and click paste valuesFri, 09 Apr 2010 21:16:08 -0500i 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.https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075194#421075194i 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.Fri, 09 Apr 2010 21:11:32 -0500If your time is in CELL A1Format the cell you want the answer in as number format and paste this into that cell=HOUR(A1)*60+MINUTE(A1)&"."&SECOND(A1)https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075190#421075190If your time is in CELL A1Format the cell you want the answer in as number format and paste this into that cell=HOUR(A1)*60+MINUTE(A1)&"."&SECOND(A1)Fri, 09 Apr 2010 21:02:09 -0500Is there any way to change a column of times done like this 1.34.56 into 94.56 ? obviously via a formula..tia.https://community.betfair.com/general_betting/go/thread/view/94082/23539006/excel-help?post_id=421075186#421075186Is there any way to change a column of times done like this 1.34.56 into 94.56 ? obviously via a formula..tia.Fri, 09 Apr 2010 19:25:58 -0500