[dba-Tech] Excel Date/time problem

How about using seperate columns which you can then concatinate as you choose?

On 5/3/06, Lembit Soobik <lembit.dbamail at t-online.de> wrote:
> well, it turns out that since I had formattet it to hh/mm/ss
> rather than hh/mm/ss/frames, which doesnt exist of course,
> (I cheated) the !§$"&"§%Excel does take the first number as hours and
> therefore doesnt allow anything beyound 24/00/00
>
> guess i have to find a better way. If nothing else then I will use Text.
>
> Lembit
>
> ----- Original Message -----
> From: "Lembit Soobik" <lembit.dbamail at t-online.de>
> To: "Discussion of Hardware and Software issues"
> <dba-tech at databaseadvisors.com>
> Sent: Wednesday, May 03, 2006 6:02 PM
> Subject: Re: [dba-Tech] Excel Date/time problem
>
>
> > just found that co copy a 'good value' to other cells in the column and
> > then
> > type over it wont help.
> > it comes back with the 01.01.1900 05/03/17
> >
> >
> >
> >>I am using Excel 2002 SP3 to list whats on my camcorder tapes-
> >> I use one column to record the location on the tape (it is shown in
> >> hours,
> >> minutes, seconds, frames.
> >> the hours are usually 0 sine that are 60 minutes tapes.
> >> I have formatted the column as hh/mm/ss
> >> something like 29 minutes, 3 seconds and 17 frames shows up as 29/03/17
> >> this works just fine up to a certain line (31).
> >> there it shows something like 05/03/17 and if I look at whats in there it
> >> shows 01.01.1900 05/03/17.
> >>
> >> it doesnt help to mark the whole column and format it as hh/mm/ss.
> >> but if I copy one cell with the correct format, then erase it and then
> >> type
> >> in the value I want, it works.
> >>
> >> any idea, what to do to make it working from the beginning on?
> >>
> >> thanks
> >> Lembit
> >>
> >> _______________________________________________
> >> dba-Tech mailing list
> >> dba-Tech at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/dba-tech
> >> Website: http://www.databaseadvisors.com
> >>
> >>
> >> --
> >> No virus found in this incoming message.
> >> Checked by AVG Free Edition.
> >> Version: 7.1.385 / Virus Database: 268.5.2/329 - Release Date: 02.05.2006
> >>
> >>
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.385 / Virus Database: 268.5.2/329 - Release Date: 02.05.2006
> >
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com