Re: TIME TO GMT and Summer time
Re: TIME TO GMT and Summer time
- Subject: Re: TIME TO GMT and Summer time
- From: Michelle Steiner <email@hidden>
- Date: Sat, 09 Jul 2011 10:39:40 -0700
On Jul 9, 2011, at 10:27 AM, Randal L. Schwartz wrote:
>>>>>> "KOENIG" == KOENIG Yvan <email@hidden> writes:
>
> KOENIG> As I already wrote here, when I extract a date_time value from a
> KOENIG> Numbers cell and insert it in an other cell, I must subtract the
> KOENIG> value TIME TO GMT because when a cell display 1943/12/31 00:00
> KOENIG> 00 the extracted value, here in France is 1943/12/31 01:00:00
>
> KOENIG> Alas, as we are in summer, TIME TO GMT is not 3600 but 7200 so
> KOENIG> the corrected value is wrong.
>
> Uh, 1943/12/31 is North Hemisphere winter, not summer. France winter is
> UTC+1, according to the sources I see.
>
> Try it again with 1943/6/1 and you would (hopefully) see a 2-hour
> offset.
Time to GMT works only with the current time. So he was trying to apply that number to the date in the cell; he was not trying to use the command directly on the cell's date.
At his location, he's 1 hour off GMT with standard time, and two hours off GMT with daylight time. His problem is in determining whether the computer is on daylight time or standard time.
-- Michelle
--
Windows Vista: Viruses, Intrusions, Spyware, Trojans, and Adware.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden