Org-mode mailing list
 help / color / mirror / Atom feed
From: "Alan E. Davis" <lngndvs@gmail.com>
To: Tim Cross <theophilusx@gmail.com>
Cc: org-mode <emacs-orgmode@gnu.org>
Subject: Re: org-table change time from UTC to other timezones
Date: Thu, 10 Dec 2020 00:10:43 -0800
Message-ID: <CAF-1L2QKXTN9EQVkXKOdV3uJi2nzDY-fTB5svLfb1j7-oZ60wg@mail.gmail.com> (raw)
In-Reply-To: <87wnxrjjl2.fsf@gmail.com>

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

I am close to throwing in the towel.

Thank you for the suggestion.  Several problems have been encountered.  I
wonder whether I understand this tool at all.   If I subtract 10:00 from
08:46, the answer given is -01:14.  I used #+TBLFM: $6=$4+$5;U, as follows
(please forgive the formatting):

| Phenom |   Date | DoW |   UTC |    Hrs |   ChST |   |
|--------+--------+-----+-------+--------+--------+---|
| ApoG   |     22 | Fr  | 06:44 | -10:00 | -03:16 |   |
|--------+--------+-----+-------+--------+--------+---|
      #+TBLFM: $6=$4+$5;U

When I add 10:00, I think the values are sensible: 21:45 + 10:00 = 31:45.

Another problem was in trying to use an inactive org timestamp.  It was not
straightforward to add or subtract N hours (say, 08:00).

This it a thornier problem than I had envisioned, anyway, because in locale
with time zones, the conversion factor will change at some point DURING the
month.

Perhaps there is a calc procedure to convert time zones that will take into
account the system's knowledge of the timezones as well as changes to/from
Daylight Time.

For now,

On Wed, Dec 9, 2020 at 3:40 AM Tim Cross <theophilusx@gmail.com> wrote:

>
> Alan E. Davis <lngndvs@gmail.com> writes:
>
> > 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?
> >
>
> Org tables support formulas which use the Emacs 'calc' program. Calc has
> pretty good support for adding, subtracting, multiplying and otherwise
> manipulating dates and times (this is how the org clocktable works). It
> should be pretty straight forward to have a column of date + time
> values, a time offset representing a timezone and a 3rd column which is
> the new date/time after applying the offset. Have a look at the secton
> in the org manual on table formulas and the calc manual in info.
>
> --
> Tim Cross
>
>

-- 
      "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: 4683 bytes --]

  reply	other threads:[~2020-12-10  8:13 UTC|newest]

Thread overview: 13+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-12-09 10:20 Alan E. Davis
2020-12-09 11:34 ` Tim Cross
2020-12-10  8:10   ` Alan E. Davis [this message]
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:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://orgmode.org

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

  git send-email \
    --in-reply-to=CAF-1L2QKXTN9EQVkXKOdV3uJi2nzDY-fTB5svLfb1j7-oZ60wg@mail.gmail.com \
    --to=lngndvs@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=theophilusx@gmail.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Org-mode mailing list

This inbox may be cloned and mirrored by anyone:

	git clone --mirror https://orgmode.org/list/0 list/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 list list/ https://orgmode.org/list \
		emacs-orgmode@gnu.org
	public-inbox-index list

Example config snippet for mirrors.
Newsgroups are available over NNTP:
	nntp://news.yhetil.org/yhetil.emacs.orgmode
	nntp://news.gmane.io/gmane.emacs.orgmode


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git