From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jeff Kowalczyk Subject: Table formula referencing cells with HH:MM time strings, incorrect result Date: Fri, 25 Sep 2009 18:41:19 +0000 (UTC) Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MrFk7-00064a-U9 for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 14:42:07 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MrFk3-00062N-Bb for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 14:42:07 -0400 Received: from [199.232.76.173] (port=38003 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MrFk3-00062I-1i for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 14:42:03 -0400 Received: from lo.gmane.org ([80.91.229.12]:54280) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1MrFk2-0004Ds-Kn for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 14:42:02 -0400 Received: from list by lo.gmane.org with local (Exim 4.50) id 1MrFjm-00032a-Rl for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 20:41:46 +0200 Received: from 24-216-241-93.dhcp.mdfd.or.charter.com ([24.216.241.93]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 25 Sep 2009 20:41:46 +0200 Received: from jtk by 24-216-241-93.dhcp.mdfd.or.charter.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 25 Sep 2009 20:41:46 +0200 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: emacs-orgmode@gnu.org 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. Thanks, Jeff