From mboxrd@z Thu Jan 1 00:00:00 1970 From: Olivier Schwander Subject: clocktable display format Date: Fri, 26 Mar 2010 17:31:29 +0100 Message-ID: <20100326163129.GA16011@pomerol.lix.polytechnique.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NvCRh-0007Hc-5w for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 12:31:41 -0400 Received: from [140.186.70.92] (port=38350 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NvCRd-0007FO-H3 for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 12:31:38 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NvCRa-0002gn-Bi for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 12:31:36 -0400 Received: from mx-a.polytechnique.fr ([129.104.30.14]:54147) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NvCRa-0002fR-2s for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 12:31:34 -0400 Received: from argos.lix.polytechnique.fr (argos.lix.polytechnique.fr [129.104.11.2]) by mx-a.polytechnique.fr (tbp 5.3.2/2.0.7) with ESMTP id o2QGVTsf003559 for ; Fri, 26 Mar 2010 17:31:30 +0100 Received: from mailhost.lix.polytechnique.fr (pomerol.lix.polytechnique.fr [129.104.11.158]) by argos.lix.polytechnique.fr (Postfix) with ESMTP id B265DF5A4D for ; Fri, 26 Mar 2010 17:31:29 +0100 (CET) Received: (from schwander@localhost) by mailhost.lix.polytechnique.fr (8.14.3/8.12.8/Submit) id o2QGVTYk020957 for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 17:31:29 +0100 Content-Disposition: inline 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 Hello, I am using clocktable to display a summary of the effort in a subtree. As I am not particularly interested in precise hourly details, I would like to display the total time in days instead of hours. Now I have: | L | Headline | Time | | |---+-----------------------+----------+--------| | | *Total time* | *528:00* | | and I would like: | L | Headline | Time | | |---+-----------------------+----------+--------| | | *Total time* | *22* | | I tried to add a formula in the table, but it doesn't work since the fields are in the format hour:minute. I suppose I could use org-babel to parse the content of the field and convert it into days but it seems rather complicated and I would be happy with a simple solution. Any ideas ? Thanks, Olivier