develooper Front page | | Postings from October 2004

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

Thread Previous | Thread Next
Stephen Turner
October 26, 2004 08:19
RE: [OT] Excel Golf: Unix Time to Excel Time in one line
Message ID:
On Tue, 26 Oct 2004, Stephen Turner wrote:
> I don't know if you can have the time in other timezones though. Excel
> doesn't seem to know about them, unless I'm missing something. I set my
> clock to Pacific time, and NOW() changed to 38286.29 (i.e. 29% of the way
> through today), and 1/1/1970 00:00:00 was still 25569.00.

In particular, your formula seems to change to summer time on the last
Sunday in April, and change back on the last Sunday in October, whereas
British Summer Time actually starts on the last Sunday in March.

To make it work in any other timezone, you would probably need to encode the
offset from GMT, and the rules for which date and time to change the clocks.

Stephen Turner, Cambridge, UK
  "Low Priced Cambridge Clare College. Big selection at eBay UK!"
  (Ad after Google search for Clare College Cambridge)

Thread Previous | Thread Next Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at | Group listing | About