From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: clocktable display format Date: Fri, 26 Mar 2010 23:18:03 +0100 Message-ID: References: <20100326163129.GA16011@pomerol.lix.polytechnique.fr> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NvHr1-0008Kk-9J for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 18:18:11 -0400 Received: from [140.186.70.92] (port=39192 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NvHqy-0008JW-EF for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 18:18:10 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NvHqx-0008Dn-0z for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 18:18:08 -0400 Received: from mail-ew0-f227.google.com ([209.85.219.227]:40096) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NvHqw-0008Dg-QU for emacs-orgmode@gnu.org; Fri, 26 Mar 2010 18:18:06 -0400 Received: by ewy27 with SMTP id 27so92326ewy.30 for ; Fri, 26 Mar 2010 15:18:05 -0700 (PDT) In-Reply-To: <20100326163129.GA16011@pomerol.lix.polytechnique.fr> 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: Olivier Schwander Cc: emacs-orgmode@gnu.org On Mar 26, 2010, at 5:31 PM, Olivier Schwander wrote: > 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 ? That is not straight forward - and I also do not think it would be so useful. Do you want 8 hour days or 24 hour days, for example? - Carsten