From mboxrd@z Thu Jan 1 00:00:00 1970 From: William Henney Subject: Re: (no subject) Date: Fri, 2 May 2014 22:01:53 -0500 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3010eb89cab9fa04f8761e7b Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:59711) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WgQD5-0007IH-9Z for emacs-orgmode@gnu.org; Fri, 02 May 2014 23:01:56 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WgQD4-0002SA-Dl for emacs-orgmode@gnu.org; Fri, 02 May 2014 23:01:55 -0400 Received: from mail-ie0-x234.google.com ([2607:f8b0:4001:c03::234]:54610) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WgQD4-0002S2-7I for emacs-orgmode@gnu.org; Fri, 02 May 2014 23:01:54 -0400 Received: by mail-ie0-f180.google.com with SMTP id as1so5979681iec.11 for ; Fri, 02 May 2014 20:01:53 -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 --20cf3010eb89cab9fa04f8761e7b Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 wr= ote: > 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 > > --=20 Dr William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3=ADsica, Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campus Morelia --20cf3010eb89cab9fa04f8761e7b Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Ryan

Convert to degrees, then multip= ly by 3600:=C2=A0

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

Cheers

Will


On Fri, May 2, 2014 at 8:52 PM, Ryan Moszynski <ryan.moszynski@gma= il.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, Campu= s Morelia
--20cf3010eb89cab9fa04f8761e7b--