From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Table formula referencing cells with HH:MM time strings, incorrect result Date: Mon, 28 Sep 2009 08:13:36 +0100 Message-ID: <6189DFC0-6A9E-4920-9A4B-5F2B9F8666F9@gmail.com> References: Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MsAyT-0008OP-CS for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 03:48:45 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MsAyO-0008Kz-Rc for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 03:48:45 -0400 Received: from [199.232.76.173] (port=37140 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MsAyO-0008Kr-Iq for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 03:48:40 -0400 Received: from mx20.gnu.org ([199.232.41.8]:4353) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1MsAyN-0005Fm-Uh for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 03:48:40 -0400 Received: from mail-ew0-f208.google.com ([209.85.219.208]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MsAyN-0007Vh-5x for emacs-orgmode@gnu.org; Mon, 28 Sep 2009 03:48:39 -0400 Received: by mail-ew0-f208.google.com with SMTP id 4so2290951ewy.31 for ; Mon, 28 Sep 2009 00:48:38 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Jeff Kowalczyk Cc: emacs-orgmode@gnu.org On Sep 25, 2009, at 7:41 PM, Jeff Kowalczyk wrote: > I am trying to use HH:MM time strings from clocktables in a table > formula. First > time I've used table formulas, BTW. > > When fetching the cells as remote(), I got strange results. The > behavior is the > same for regular references, so here's a regular-reference test case: > > | 17:36 | 17:36 | > | 19:45 | 19:45 | > | 24:53 | 24:53 | > | 40:57 | 40:57 | > | 43:02 | 43:2 | > | 45:14 | 45:14 | > | 46:09 | 46:9 | > | 48:56 | 6:7 | > | 49:28 | 7:4 | > | 55:18 | 55:18 | > | 80:10 | 8 | > | 88:14 | 44:7 | > #+TBLFM: $2=$1 > > The objective is to multiply time (decimal) by a constant, so if > anyone has a > tip for parsing HH:MM using a function instead of reinventing, > thanks in advance. HH:MM is interpreted by calc a integer division. For example 80/10 = 8 and 49/28=7/4 I think for this kind of stuff you need to work with Emacs lisp formulas, for example #+TBLFM: $2='(/ (float (org-hh:mm-string-to-minutes $1)) 60.);%.2f HTH - Carsten > > Thanks, > Jeff > > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode