From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Re: Calc: Multiply time (hours) with a float - solved by updating Org Date: Tue, 20 Sep 2016 16:23:17 +0200 Message-ID: <2016-09-20T16-18-01@devnull.Karl-Voit.at> 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> Reply-To: Karl Voit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50527) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmLxl-0005fo-Sc for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 10:24:01 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bmLxf-0005QO-8k for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 10:23:54 -0400 Received: from [195.159.176.226] (port=33661 helo=blaine.gmane.org) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmLxf-0005Nb-2c for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 10:23:51 -0400 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1bmLxT-00066N-My for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 16:23:39 +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 * Karl Voit wrote: > > | time [h:m:s] | value | product | > |--------------+---------+---------| > | 09:15:00 | 2.54321 | #ERROR | > #+TBLFM: @2$3='(org-time-string-to-hours $1) > > OK, this is my current issue then. > > I'm using Org from git/maint version 8.3.4 > (release_8.3.4-33-gd522fc) and GNU Emacs 24.5.1 (i686-pc-mingw32 > Windows) as well as Emacs 24.4.1 on GNU/Linux. I updated to Org-mode version 8.3.4 (release_8.3.4-115-gf46b92): | time [h:m:s] | value | product | |--------------+---------+---------| | 09:15:00 | 2.54321 | 9.25 | #+TBLFM: @2$3='(org-time-string-to-hours $1) ... now works after Org update. | time [h:m:s] | value | product | |--------------+---------+------------| | 09:15:00 | 2.54321 | 23.5246925 | #+TBLFM: @2$3='(* $2 (org-time-string-to-hours "$1"));L ... now works as well. I am so sorry that this took you so much time just because of my old code. However, I learned a lot from your comments - Thanks for that! :-) -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: > get Memacs from https://github.com/novoid/Memacs < https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github