emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* org-table change time from UTC to other timezones
@ 2020-12-09 10:20 Alan E. Davis
  2020-12-09 11:34 ` Tim Cross
  0 siblings, 1 reply; 13+ messages in thread
From: Alan E. Davis @ 2020-12-09 10:20 UTC (permalink / raw)
  To: org-mode

[-- 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
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
<https://www.dartmouth.edu/~library/digital/publishing/meadows/ltg/>.
(p. 81)

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

^ permalink raw reply	[flat|nested] 13+ messages in thread

end of thread, other threads:[~2020-12-14  2:30 UTC | newest]

Thread overview: 13+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2020-12-09 10:20 org-table change time from UTC to other timezones Alan E. Davis
2020-12-09 11:34 ` 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

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

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