Re: TIME TO GMT and Summer time
Re: TIME TO GMT and Summer time
- Subject: Re: TIME TO GMT and Summer time
- From: KOENIG Yvan <email@hidden>
- Date: Sat, 09 Jul 2011 20:00:55 +0200
Le 9 juil. 2011 à 19:39, Michelle Steiner a écrit :
>
> 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
Thanks Michelle. I assumed that my wording was not clear.
Yvan KOENIG (VALLAURIS, France) samedi 9 juillet 2011 20:00:50
_______________________________________________
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