From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Welle Subject: Re: Calc: Multiply time (hours) with a float Date: Mon, 19 Sep 2016 19:45:07 +0200 Message-ID: <87ponzkcm4.fsf@luisa.c0t0d0s0.de> References: <2016-09-08T10-32-27@devnull.Karl-Voit.at> <2016-09-11T13-43-22@devnull.Karl-Voit.at> <87oa3u1vpn.fsf@luisa.c0t0d0s0.de> <2016-09-18T18-32-24@devnull.Karl-Voit.at> <874m5cs7tq.fsf@luisa.c0t0d0s0.de> <87oa3kqsy3.fsf@luisa.c0t0d0s0.de> <2016-09-19T13-38-25@devnull.Karl-Voit.at> <87a8f4m596.fsf@luisa.c0t0d0s0.de> <2016-09-19T14-57-54@devnull.Karl-Voit.at> <87shswkniq.fsf@luisa.c0t0d0s0.de> <87zin352ga.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:59646) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bm2d0-0008QN-Sx for emacs-orgmode@gnu.org; Mon, 19 Sep 2016 13:45:16 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bm2cw-0006a4-Ln for emacs-orgmode@gnu.org; Mon, 19 Sep 2016 13:45:13 -0400 Received: from mout.gmx.net ([212.227.17.22]:52283) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bm2cw-0006YD-5v for emacs-orgmode@gnu.org; Mon, 19 Sep 2016 13:45:10 -0400 Received: from stella.c0t0d0s0.de ([88.66.7.109]) by mail.gmx.com (mrgmx101) with ESMTPSA (Nemesis) id 0Lu3J4-1aoGWo15Fu-011R1m for ; Mon, 19 Sep 2016 19:45:08 +0200 Received: from Stella (stella.c0t0d0s0.de [192.168.42.1]) by stella.c0t0d0s0.de (Postfix) with ESMTP id 6070DC4264 for ; Mon, 19 Sep 2016 19:45:07 +0200 (CEST) In-Reply-To: <87zin352ga.fsf@gmail.com> (Nick Dokos's message of "Mon, 19 Sep 2016 11:33:41 -0400") 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" To: emacs-orgmode@gnu.org Hello, Nick Dokos writes: > Michael Welle writes: > >> Hello, >> >> Karl Voit writes: >> >>> * Michael Welle wrote: >>>> >>>> Karl Voit writes: >>>> >>>>>> [...] >>>>>>> #+TBLFM: @2$3='(* $2 (org-time-string-to-hours "$1"));L >>>>>> or converting $2 to a number before the calculation should work also, >>>>>> but is more to write ;). >>>>> >>>>> Hm. I still got #ERROR. I reduced my issue to calculate the float >>>>> (for hours) >>>>> without multiplying it with "value": >>>> strange. I use the current Org version from git and Emacs 25.1. >>>> >>>>> | time [h:m:s] | value | product | >>>>> |--------------+---------+---------| >>>>> | 09:15:00 | 2.54321 | #ERROR | >>>>> >>>>> #+TBLFM: @2$3='(org-time-string-to-hours $1) I'm just back from a 20km hike and in the woods my mind came up with a silly question ;). This empty line, that we see between the table above and the formula, does that exist in your real Org file? If so, and if the point is on the formula when you press C-cC-c, the table doesn't change, i.e., the error mark doesn't go away even if the formula is correct. Regards hmw