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 http://homepage.ntlworld.com/adelie/stephen/ "Low Priced Cambridge Clare College. Big selection at eBay UK!" (Ad after Google search for Clare College Cambridge)
