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

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

Thread Previous | Thread Next
From:
Keith C. Ivey
Date:
October 26, 2004 06:45
Subject:
Re: [OT] Excel Golf: Unix Time to Excel Time in one line
Message ID:
E1CMRe0-0004T3-00@smtp02.mrf.mail.rcn.net
Stephen Turner <sret1@ntlworld.com> wrote:

> I don't know much about Excel, but I think DATE(1970,1,1) can be
> spelled 25569. If I'm right, that would save you at least 63
> strokes.

Also, "/24/60/60" can be spelled "/86400".  That saves another 
21.

-- 
Keith C. Ivey <kcivey@cpcug.org>
Washington, DC


Thread Previous | Thread Next


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