From mboxrd@z Thu Jan 1 00:00:00 1970 From: Axel Kielhorn Subject: Collectable results in minutes instead of HH:MM Date: Wed, 13 Jan 2016 17:54:11 +0100 Message-ID: <6BF9CF4B-DA4F-4DE3-B32E-C961A76DACB4@axelkielhorn.de> Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\)) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:39473) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aJOmN-0000kF-Tp for emacs-orgmode@gnu.org; Wed, 13 Jan 2016 12:00:19 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1aJOmN-0000Lh-2t for emacs-orgmode@gnu.org; Wed, 13 Jan 2016 12:00:15 -0500 Received: from mo6-p00-ob.smtp.rzone.de ([2a01:238:20a:202:5300::4]:54244) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aJOmM-0000L2-Pe for emacs-orgmode@gnu.org; Wed, 13 Jan 2016 12:00:15 -0500 Received: from [IPv6:2003:73:2f05:b400:1ddb:f921:56a9:e535] (p200300732F05B4001DDBF92156A9E535.dip0.t-ipconnect.de [IPv6:2003:73:2f05:b400:1ddb:f921:56a9:e535]) by smtp.strato.de (RZmta 37.15 AUTH) with ESMTPSA id N03f18s0DGsCKCS (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (curve secp521r1 with 521 ECDH bits, eq. 15360 bits RSA)) (Client did not present a certificate) for ; Wed, 13 Jan 2016 17:54:12 +0100 (CET) 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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Org-Mode Mailing List Hi, I use org mode to clock the time I spend on different tasks. Starting this year my company switched to account working time by the = minute instead of using a quarter of an hour. Getting the exact time is no problem but right now I have to translate = the HH:MM time into minutes since that is what the accounting software = needs. When I use=20 org-time-clocksum-use-fractional I can use a TBLFM and the result is almost right, but has rounding = errors. (Increasing the rational part to 3 digits will probably help with the = rounding errors.) Without it I get the HH:MM and simply multiplying the result by 60 does not work. I prefer the HH:MM format and am looking for a way to convert that. Can anyone help? Axel