develooper Front page | perl.golf | Postings from October 2004

Re: [OT] Excel Golf: Unix Time to Excel Time in one line

Thread Previous
From:
Jasper
Date:
October 26, 2004 06:25
Subject:
Re: [OT] Excel Golf: Unix Time to Excel Time in one line
Message ID:
81cd84130410260625d7c72d1@mail.gmail.com
On Tue, 26 Oct 2004 13:58:04 +0100, McGlinchy, Alistair
<alistair.mcglinchy@marks-and-spencer.com> wrote:

> =       DATE(1970,1,1)+ A2/24/60/60+1/24 *
>        AND(
>                DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),5,1)
>                        -
>                WEEKDAY(DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),5,1),2)
>                        +
>                1/24
>        <
>                DATE(1970,1,1)+A2/24/60/60
>        ,
>                DATE(1970,1,1)+A2/24/60/60
>        <
>                DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),11,1)
>                        -
>                WEEKDAY(DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),11,1),2)
>                        +
>                1/24
>        )

Would another cell with DATE(1970,1,1)+A2/24/60/60 in it not help matters a bit?

I know nothing about excel

-- 
Jasper

Thread Previous


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About