[dba-Tech] Excel Date/time problem

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
>