From mboxrd@z Thu Jan 1 00:00:00 1970 From: William Henney Subject: Re: (no subject) Date: Fri, 2 May 2014 22:22:28 -0500 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=089e015383f6643fc304f87668bd Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33004) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WgQX4-0001h6-GL for emacs-orgmode@gnu.org; Fri, 02 May 2014 23:22:35 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WgQWy-0000Kp-SS for emacs-orgmode@gnu.org; Fri, 02 May 2014 23:22:34 -0400 Received: from mail-ig0-x233.google.com ([2607:f8b0:4001:c05::233]:65030) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WgQWy-0000Kg-Kp for emacs-orgmode@gnu.org; Fri, 02 May 2014 23:22:28 -0400 Received: by mail-ig0-f179.google.com with SMTP id hn18so2687692igb.6 for ; Fri, 02 May 2014 20:22:28 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Ryan Moszynski Cc: emacs-org --089e015383f6643fc304f87668bd Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Or, even better, just divide by the HMS form for 1 second (0@ 0' 1"): | - | - | - | 1@ 11' 37" | - | - | - | 4297 | #+TBLFM: $8=3D$4 \ 0@ 0' 1" Note that \ is integer division, so there is no need for a format conversio= n Will P.S. I highly recommend reading the [[info:calc#Basic Arithmetic]] section of the calc manual On Fri, May 2, 2014 at 10:01 PM, William Henney wrote: > Hi Ryan > > Convert to degrees, then multiply by 3600: > > | - | - | - | 1@ 11' 37" | - | - | - | 4297 | > #+TBLFM: $8=3D3600 deg($4); %d > > Cheers > > Will > > > > On Fri, May 2, 2014 at 8:52 PM, Ryan Moszynski = wrote: > >> If an org table cell contains the HMS 1@ 11' 37" >> >> is there an easy way to get the total (time)seconds? >> >> (1*3600 + 11*60 + 37 =3D 4297) >> >> >> if $4 =3D 1@ 11' 37" >> >> how do I get $8 =3D 4297? >> >> thanks >> >> ryan >> >> -- >> He felt that his whole life was some kind of dream and he sometimes >> wondered whose it was and whether they were enjoying it. - Douglas >> Adams >> >> > > > -- > > Dr William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3=ADsica, > Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campus Morelia > --=20 Dr William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3=ADsica, Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campus Morelia --089e015383f6643fc304f87668bd Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Or, even better, just divide by the HMS form for 1 second = (0@ 0' 1"):=C2=A0

| - | - | - | 1@ 11'= 37" | - | - | - | 4297 |
#+TBLFM: $8=3D$4 \ 0@ 0' 1&quo= t;

Note that \ is integer division, so there is no n= eed for a format conversion

Will

P.S. I highly recommend reading the=C2=A0[[info:calc#Basic Arithmet= ic]] section of the calc manual



On Fri, May 2, 2014 at 10:01 PM, William Henney &= lt;whenney@gmail.com= > wrote:
Hi Ryan

= Convert to degrees, then multiply by 3600:=C2=A0

<= div>
| - | - | - | 1@ 11' 37" | - | - | - | 4297 |
#+TBLFM: $= 8=3D3600 deg($4); %d

Cheers

Will


On Fri, May 2, 2014 at 8:52 PM, Ryan Moszynski <ryan.moszynski@gmail.com> wrote:
If an org table cell contains the HMS 1@ 11&= #39; 37"

is there an easy way to get the total (time)seconds?

(1*3600 + 11*60 + 37 =3D 4297)


if $4 =3D =C2=A01@ 11' 37"

how do I get $8 =3D 4297?

thanks

ryan

--
He felt that his whole life was some kind of dream and he sometimes
wondered whose it was and whether they were enjoying it. - Douglas
Adams




--

=C2=A0 Dr = William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3=ADsica,
=C2= =A0 Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campus Morelia



--

=C2=A0 D= r William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3=ADsica,
=C2= =A0 Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campus Morelia
--089e015383f6643fc304f87668bd--