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
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
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
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
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,
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:
> > > >
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
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
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
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
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
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
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
[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
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
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
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
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
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
19 matches
Mail list logo