From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id HPENLMek0F8nGQAA0tVLHw (envelope-from ) for ; Wed, 09 Dec 2020 10:19:51 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id KFKaJ8ek0F9zGgAA1q6Kng (envelope-from ) for ; Wed, 09 Dec 2020 10:19:51 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 2C05A940111 for ; Wed, 9 Dec 2020 10:19:51 +0000 (UTC) Received: from localhost ([::1]:51354 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kmwZa-00033c-5E for larch@yhetil.org; Wed, 09 Dec 2020 05:19:50 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:40140) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kmwYG-00030Q-Hs for emacs-orgmode@gnu.org; Wed, 09 Dec 2020 05:18:28 -0500 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]:40415) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kmwYE-0000FO-OJ for emacs-orgmode@gnu.org; Wed, 09 Dec 2020 05:18:28 -0500 Received: by mail-wm1-x336.google.com with SMTP id a3so1051283wmb.5 for ; Wed, 09 Dec 2020 02:18:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=xVBThYQdXUm05Uy/KK9Ijf9aYgbYnDYDs5r1OVX1azM=; b=BhTd3C7/kSYhPsp+XGvMcBYJHUOOWxG2vSPRHlfzFeyQj3RzKEuNEvZc0KNxk0gDuO hIk41gzahdaaaKwVRZQKXkP3Hp30Xy6T5pCXYVtcZeYe3CZayHj+LOdJizgvHIfgAcTQ ifYEzcpfcYENQQgr95L+RSXHgUiaSC51XQBpW1+4L1XYhHTT+AlXnAU+znk6eN9YFom3 OYlJzq/XgCjAYpoXSrfI8FQJLBbyaP0e9L1DyMWfuxmJtAHct0+i7V9ZYwN1tyiDj64z lknklNO54KtA9107bNTtyZGfCUf7e5YpObxFNZNylLKhAOOm9g0EW94KMuuy7k9XDjK5 LRqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=xVBThYQdXUm05Uy/KK9Ijf9aYgbYnDYDs5r1OVX1azM=; b=qS22bkjkQ+Zhirx6hXJM/T5HFHv7oZZMnllA4Fn2hjClSsEmOyyvBV1G4jOVhMTkRR e4AbDZWBLDnCmnYrEh6pAtgoiFUrLljMF0x67p8HcPqwZhhL5z+zllMDL5UhM9adENGn ZeDKVGumBDUJ3QUEtwfI6ror8z3VU94obM698s8sKIcwAbU+Tf6di8mGMKRl7Rpp8xfV 1V/Cg0W/uRhnkZz6cDaghoyU5vRoMydiIrkHyaFkXPn2GPbfOVhibECrB/PzlMlspHeh BzVG6D6wdW6Ym/Logdjp7Vri2QfuKkDNRJXAPgGnkvzGNghbCBDzT3vgMAWtOW2HRy1D UTaA== X-Gm-Message-State: AOAM533DFp934EpgnijKj1tVqQgjXfqfGOuUDMf/ACVP07DzCfvvvN5Q Gy8Gq1B70lHhje+MY//+Xgpq3WkYYUl6KRMDZ8cuCRilfKg= X-Google-Smtp-Source: ABdhPJyH04B30LblzHyUOFNW0uxgirll9WsVa1oeBO7FVZUxcrMQcfUwcGkhrSwR0oja/od9QoZmGI1nIxRZd/j9WqU= X-Received: by 2002:a7b:cb0c:: with SMTP id u12mr1925513wmj.11.1607509104141; Wed, 09 Dec 2020 02:18:24 -0800 (PST) MIME-Version: 1.0 From: "Alan E. Davis" Date: Wed, 9 Dec 2020 02:20:05 -0800 Message-ID: Subject: org-table change time from UTC to other timezones To: org-mode Content-Type: multipart/alternative; boundary="000000000000202a3705b60561cb" Received-SPF: pass client-ip=2a00:1450:4864:20::336; envelope-from=lngndvs@gmail.com; helo=mail-wm1-x336.google.com X-Spam_score_int: 7 X-Spam_score: 0.7 X-Spam_bar: / X-Spam_report: (0.7 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, FROM_LOCAL_NOVOWEL=0.5, HK_RANDOM_ENVFROM=0.001, HK_RANDOM_FROM=0.346, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URI_DOTEDU=1.999 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -1.51 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=BhTd3C7/; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: 2C05A940111 X-Spam-Score: -1.51 X-Migadu-Scanner: ns3122888.ip-94-23-21.eu X-TUID: ztw3IyYPi6iM --000000000000202a3705b60561cb Content-Type: text/plain; charset="UTF-8" I have been pleased to learn that I can add / subtract hours in org-table to shift time zones. I am making tables of lunar/solar parameters relevant to tides. Org-table is a convenient way to enter data in a tabular format that can be printed via LaTeX. So each year, for several time zones, I enter these times by hand. It's very, very easy, I have learned, to collect all of these times (at most, maybe 12 per month) for UTC, and add or subtract to generate a column of times for a new time zone. Very Slick! Except that when I add, for example. 09:00 to 23:33, I guess it is pretty obvious what is going to happen: it would be the same day, but at 32:33 !! I have tripped up on trying to test for whether the sum is greater than or equal to 24:00, and then doing something interesting with it. It's actually pretty easy to go through all the months and find the exceptions, and make manual changes. But, as I usually have done, I would rather spend a few hours coming up with some programmatic method for making this work automatically! The other problem is the change of the day. I suppose I could use 0, 1, 2... for Sunday, Monday, Tuesday... (I am living in the United States). Has someone solved this problem? Thank you, Alan Davis -- "This ignorance about the limits of the earth's ability to absorb pollutants should be reason enough for caution in the release of polluting substances." ---Meadows et al. 1972. Limits to Growth . (p. 81) --000000000000202a3705b60561cb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have been pleased to learn that I can add / subtrac= t hours in org-table to shift time zones.=C2=A0 I am making tables of=C2=A0= lunar/solar parameters relevant to tides.=C2=A0 Org-table is a convenient = way to enter data in a tabular format that can be printed via LaTeX.=C2=A0 = So each year, for several time zones, I enter these times by hand.=C2=A0=C2= =A0

It's very, very easy, I have learned,= to collect all of these times (at most, maybe 12 per month) for UTC, and a= dd or subtract to generate a column of times for a new time zone.=C2=A0 Ver= y Slick!

Except that when I add, for example. 09:0= 0 to 23:33, I guess it is pretty obvious what is going to happen: it would = be the same day, but at 32:33 !!

I have tripped up= on trying to test for whether the sum is greater than or equal to 24:00, a= nd then doing something interesting with it.=C2=A0 It's actually pretty= easy to go through all the months and find the exceptions, and make manual= changes.=C2=A0 But, as I usually have done, I would rather spend a few hou= rs coming up with some programmatic method for making this work automatical= ly!=C2=A0=C2=A0

The other problem is the chan= ge of the day.=C2=A0 I suppose I could use 0, 1, 2... for Sunday, Monday, T= uesday...=C2=A0 (I am living in the United States).=C2=A0
Has someone solved this problem?

Than= k you,

Alan Davis

-- <= br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 "This ig= norance about the limits of the earth's ability to absorb
=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 pollutants should be reason enough for caution = in the release
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 of polluting substan= ces."
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0=C2=A0 ---Meadows et al.=C2=A0=C2=A0 1972.= =C2=A0 Limits to Growth. =C2=A0=C2=A0 =C2=A0 (p. 81)=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0
--000000000000202a3705b60561cb--