Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-10 Thread [EMAIL PROTECTED]
On Dec 10, 3:49 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 9 Dez., 18:38, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > > > > > > On Dec 9, 8:52�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > On 7 Dez., 22:36, John Machin <[EMAIL PROTECTED]> wrote: > > > > > On Dec 8, 12:20 am, Di

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-10 Thread Dirk Hagemann
On 9 Dez., 18:38, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > On Dec 9, 8:52�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > On 7 Dez., 22:36, John Machin <[EMAIL PROTECTED]> wrote: > > > > On Dec 8, 12:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > Hello, > > > > > From a zo

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-09 Thread [EMAIL PROTECTED]
On Dec 9, 8:52�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 22:36, John Machin <[EMAIL PROTECTED]> wrote: > > > > > > > On Dec 8, 12:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > Hello, > > > > From a zone-file of a Microsoft Active Directory integrated DNS server > > > I get

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-09 Thread Dirk Hagemann
On 7 Dez., 22:36, John Machin <[EMAIL PROTECTED]> wrote: > On Dec 8, 12:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > Hello, > > > From a zone-file of a Microsoft Active Directory integrated DNS server > > I get the date/time of the dynamic update entries in a format, which > > is as far as

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread John Machin
On Dec 8, 12:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > Hello, > > From a zone-file of a Microsoft Active Directory integrated DNS server > I get the date/time of the dynamic update entries in a format, which > is as far as I know the hours since january 1st 1901. As Tim Golden has guessed,

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread [EMAIL PROTECTED]
On Dec 7, 9:59 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > > > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > [EMAIL PROTECTED] wrote: > > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > >

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Boris Borcic
Dirk Hagemann wrote: > (3566839/24)/365 = 407 - YES I did this calculation too and was > surprised. But if you try this out in MS Excel: > ="01.01.1901"+(A1/24-(REST(A1;24)/24))+ZEIT(REST(A1;24);0;0) (put > 3566839 in field A1 and switch the format of the result-fieldby right- > click on it to

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Max Erickson
Dirk Hagemann <[EMAIL PROTECTED]> wrote: >> Dirk > Additional to my last posting: if you want to try this out in > Excel you should replace the command "REST" by the english > command what should be something like "remainder". The equivalent in my (U.S. English, 2000) version of excel is called

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Zentrader
If we use minutes from 2001, then 3566839 comes out as sometime in October, 2007 (6.78622 years). Close but no cigar. Is anyone familar enough with Excel to translate the formula or do we have to go a- googling? -- http://mail.python.org/mailman/listinfo/python-list

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > > [EMAIL PROTECTED] wrote: > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > >> Hello, > > > >> From a zone-file of a Microsoft Active Directory integrate

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:50, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > > > > > [EMAIL PROTECTED] wrote: > > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > >> Hello, > > > >> From a zone-file of a Microsoft Active Directory integrate

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 16:21, Tim Golden <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > >> Hello, > > >> From a zone-file of a Microsoft Active Directory integrated DNS server > >> I get the date/time of the dynamic update entries in a fo

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Giles Brown
On 7 Dec, 13:20, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > Hello, > > From a zone-file of a Microsoft Active Directory integrated DNS server > I get the date/time of the dynamic update entries in a format, which > is as far as I know the hours since january 1st 1901. > For Example: the number 3566

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Tim Golden
[EMAIL PROTECTED] wrote: > On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: >> Hello, >> >> From a zone-file of a Microsoft Active Directory integrated DNS server >> I get the date/time of the dynamic update entries in a format, which >> is as far as I know the hours since january 1st 19

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread supercooper
On Dec 7, 8:15 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > On 7 Dez., 14:34, supercooper <[EMAIL PROTECTED]> wrote: > > > > > On Dec 7, 7:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > Hello, > > > > From a zone-file of a Microsoft Active Directory integrated DNS server > > > I get the

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread [EMAIL PROTECTED]
On Dec 7, 7:20�am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > Hello, > > From a zone-file of a Microsoft Active Directory integrated DNS server > I get the date/time of the dynamic update entries in a format, which > is as far as I know the hours since january 1st 1901. Your guess appears to be of

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
On 7 Dez., 14:34, supercooper <[EMAIL PROTECTED]> wrote: > On Dec 7, 7:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > > > > > Hello, > > > From a zone-file of a Microsoft Active Directory integrated DNS server > > I get the date/time of the dynamic update entries in a format, which > > is as far

Re: Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread supercooper
On Dec 7, 7:20 am, Dirk Hagemann <[EMAIL PROTECTED]> wrote: > Hello, > > From a zone-file of a Microsoft Active Directory integrated DNS server > I get the date/time of the dynamic update entries in a format, which > is as far as I know the hours since january 1st 1901. > For Example: the number 35

Converting Excel time-format (hours since 1.1.1901)

2007-12-07 Thread Dirk Hagemann
Hello, >From a zone-file of a Microsoft Active Directory integrated DNS server I get the date/time of the dynamic update entries in a format, which is as far as I know the hours since january 1st 1901. For Example: the number 3566839 is 27.11.07 7:00. To calculate this in Excel I use this: ="01.01