• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: TIME TO GMT and Summer time
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: TIME TO GMT and Summer time


  • Subject: Re: TIME TO GMT and Summer time
  • From: email@hidden (Randal L. Schwartz)
  • Date: Sat, 09 Jul 2011 10:27:23 -0700

>>>>> "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.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<email@hidden> <URL:http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.posterous.com/ for Smalltalk discussion
 _______________________________________________
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

  • Follow-Ups:
    • Re: TIME TO GMT and Summer time
      • From: KOENIG Yvan <email@hidden>
    • Re: TIME TO GMT and Summer time
      • From: Michelle Steiner <email@hidden>
References: 
 >TIME TO GMT and Summer time (From: KOENIG Yvan <email@hidden>)

  • Prev by Date: Executing AppleScripts in multithreaded Cocoa App
  • Next by Date: Re: TIME TO GMT and Summer time
  • Previous by thread: TIME TO GMT and Summer time
  • Next by thread: Re: TIME TO GMT and Summer time
  • Index(es):
    • Date
    • Thread