entering time "Glen in Orlando" <Noemail[ at ]abc.com> 26.09.2006 23:13:22 hello all.. wondering if there is any way to do this... I have a column formatted for time as in this format 12:00 when entering a time it is cumbersome to have to enter the hour, then a colon, then the minutes. Is it possilbe to simply enter a 4 digit number such as 1245 and have it show up as 12:45 ?? thanks so much... I've found this group to be irreplaceable... glen in orlando

Re: entering time "Tod" <toddiSAFETYPIN[ at ]lineone.net> 26.09.2006 23:40:25 Enter your times without colons in column A and put this formula in column B =(A1-RIGHT(A1,2))/2400+RIGHT(A1,2)/(24*60) and format column B for "Time" in the form you want it. Tod "Glen in Orlando" <Noemail[ at ]abc.com> wrote in message news:muiSg.19290$Rr.17121[ at ]tornado.tampabay.rr.com... [Quoted Text] > hello all.. > wondering if there is any way to do this... > > I have a column formatted for time as in this format 12:00 > when entering a time it is cumbersome to have to enter the hour, then a > colon, then the minutes. > Is it possilbe to simply enter a 4 digit number such as 1245 and have it > show up as 12:45 ?? > > thanks so much... I've found this group to be irreplaceable... > > glen in orlando > >

Re: entering time "RagDyer" <RagDyer[ at ]cutoutmsn.com> 26.09.2006 23:53:14 You can try this: http://tinyurl.com/r3ngw -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Glen in Orlando" <Noemail[ at ]abc.com> wrote in message news:muiSg.19290$Rr.17121[ at ]tornado.tampabay.rr.com... [Quoted Text] > hello all.. > wondering if there is any way to do this... > > I have a column formatted for time as in this format 12:00 > when entering a time it is cumbersome to have to enter the hour, then a > colon, then the minutes. > Is it possilbe to simply enter a 4 digit number such as 1245 and have it > show up as 12:45 ?? > > thanks so much... I've found this group to be irreplaceable... > > glen in orlando > >

Re: entering time "Glen in Orlando" <Noemail[ at ]abc.com> 29.09.2006 21:12:24 thanks guys!! glen "RagDyer" <RagDyer[ at ]cutoutmsn.com> wrote in message news:%23ehxsbc4GHA.2264[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > You can try this: > > http://tinyurl.com/r3ngw > > -- > HTH, > > RD > > --------------------------------------------------------------------------- > Please keep all correspondence within the NewsGroup, so all may benefit ! > --------------------------------------------------------------------------- > "Glen in Orlando" <Noemail[ at ]abc.com> wrote in message > news:muiSg.19290$Rr.17121[ at ]tornado.tampabay.rr.com... >> hello all.. >> wondering if there is any way to do this... >> >> I have a column formatted for time as in this format 12:00 >> when entering a time it is cumbersome to have to enter the hour, then a >> colon, then the minutes. >> Is it possilbe to simply enter a 4 digit number such as 1245 and have it >> show up as 12:45 ?? >> >> thanks so much... I've found this group to be irreplaceable... >> >> glen in orlando >> >> >