emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: "Alan E. Davis" <lngndvs@gmail.com>
To: org-mode <emacs-orgmode@gnu.org>
Subject: org-table change time from UTC to other timezones
Date: Wed, 9 Dec 2020 02:20:05 -0800	[thread overview]
Message-ID: <CAF-1L2Qzc8tfPgr=Ez+PNhHmHjgtm6Wq5PyAgCku337ANOMRig@mail.gmail.com> (raw)

[-- Attachment #1: Type: text/plain, Size: 1575 bytes --]

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

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)

[-- Attachment #2: Type: text/html, Size: 2323 bytes --]

             reply	other threads:[~2020-12-09 10:19 UTC|newest]

Thread overview: 13+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-12-09 10:20 Alan E. Davis [this message]
2020-12-09 11:34 ` org-table change time from UTC to other timezones Tim Cross
2020-12-10  8:10   ` Alan E. Davis
2020-12-10 19:01     ` Tim Cross
2020-12-11  0:12       ` Alan E. Davis
2020-12-11 15:40         ` Maxim Nikulin
2020-12-11 22:44           ` Alan E. Davis
2020-12-12 16:04             ` Maxim Nikulin
2020-12-12 22:52               ` Tim Cross
2020-12-13  3:14                 ` Alan E. Davis
2020-12-13 17:03                   ` Maxim Nikulin
2020-12-14  2:29                     ` Alan E. Davis
2020-12-12  3:31           ` Jean Louis

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to='CAF-1L2Qzc8tfPgr=Ez+PNhHmHjgtm6Wq5PyAgCku337ANOMRig@mail.gmail.com' \
    --to=lngndvs@gmail.com \
    --cc=emacs-orgmode@gnu.org \


* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox


This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).