From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Welle Subject: Re: Calc: Multiply time (hours) with a float Date: Sun, 11 Sep 2016 14:12:36 +0200 Message-ID: <87oa3u1vpn.fsf@luisa.c0t0d0s0.de> References: <2016-09-08T10-32-27@devnull.Karl-Voit.at> <2016-09-11T13-43-22@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:42911) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bj3cq-0000U4-17 for emacs-orgmode@gnu.org; Sun, 11 Sep 2016 08:12:44 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bj3cm-0002sn-Qb for emacs-orgmode@gnu.org; Sun, 11 Sep 2016 08:12:43 -0400 Received: from mout.gmx.net ([212.227.15.19]:64225) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bj3cm-0002sb-H0 for emacs-orgmode@gnu.org; Sun, 11 Sep 2016 08:12:40 -0400 Received: from stella.c0t0d0s0.de ([88.66.7.109]) by mail.gmx.com (mrgmx001) with ESMTPSA (Nemesis) id 0LoEwL-1b7X4u0BxZ-00gKkd for ; Sun, 11 Sep 2016 14:12:37 +0200 Received: from Stella (stella.c0t0d0s0.de [192.168.42.1]) by stella.c0t0d0s0.de (Postfix) with ESMTP id 5712EC4264 for ; Sun, 11 Sep 2016 14:12:36 +0200 (CEST) In-Reply-To: <2016-09-11T13-43-22@devnull.Karl-Voit.at> (Karl Voit's message of "Sun, 11 Sep 2016 13:45:21 +0200") 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, Karl Voit writes: > * Karl Voit wrote: >> Hi! >> >> I do have following situation: I'd like to multiply a float with hours >> which results in an error, obviously. However, I was not able to find >> out how to do it. >> >> Minimal example with expected product: >> >> | time [h:m:s] | value | h * value | >> |--------------+---------+-----------| >> | 09:15:00 | 2.54321 | 23.524693 | >> #+TBLFM: @2$3=$2*$1 > > I guess the last resort would be to do this would be with an elisp > function. > > Is there no other way? do you really need the result to be in decimal notation? If not, #+TBLFM:@2$3=$2*$1;T would work. If you need decimal notation you have to provide your own function, I think. Regards hmw