From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniele Pizzolli <dan@toel.it>
Subject: Re: [bug] how to specify the format for clock table summaries and
 bug in formula calculations
Date: Sun, 29 Sep 2013 15:24:42 +0200
Message-ID: <52482A1A.5030306@toel.it>
References: <87ioxjbyew.fsf@ucl.ac.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:46027)
	by lists.gnu.org with esmtp (Exim 4.71) (envelope-from <dan@toel.it>)
	id 1VQGzl-0002BP-Sf
	for emacs-orgmode@gnu.org; Sun, 29 Sep 2013 09:25:17 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <dan@toel.it>) id 1VQGza-0005lG-1H
	for emacs-orgmode@gnu.org; Sun, 29 Sep 2013 09:25:09 -0400
Received: from relay5-d.mail.gandi.net ([217.70.183.197]:60682)
	by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from <dan@toel.it>)
	id 1VQGzZ-0005l3-RJ
	for emacs-orgmode@gnu.org; Sun, 29 Sep 2013 09:24:57 -0400
Received: from mfilter2-d.gandi.net (mfilter2-d.gandi.net [217.70.178.140])
	by relay5-d.mail.gandi.net (Postfix) with ESMTP id 0DE9341C060
	for <emacs-orgmode@gnu.org>; Sun, 29 Sep 2013 15:24:47 +0200 (CEST)
Received: from relay5-d.mail.gandi.net ([217.70.183.197])
	by mfilter2-d.gandi.net (mfilter2-d.gandi.net [10.0.15.180])
	(amavisd-new, port 10024)
	with ESMTP id TKFW4qeMetXJ for <emacs-orgmode@gnu.org>;
	Sun, 29 Sep 2013 15:24:45 +0200 (CEST)
Received: from [10.0.0.235]
	(host159-38-static.38-79-b.business.telecomitalia.it [79.38.38.159])
	(Authenticated sender: me@toel.it)
	by relay5-d.mail.gandi.net (Postfix) with ESMTPSA id F3C5D41C05C
	for <emacs-orgmode@gnu.org>; Sun, 29 Sep 2013 15:24:43 +0200 (CEST)
In-Reply-To: <87ioxjbyew.fsf@ucl.ac.uk>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org

On 09/29/2013 02:33 PM, Eric S Fraga wrote:
> Hello,

Hello Eric,

> I am clocking a number of tasks and need a summary.  The functionality
> provided by the org-clock table is ideal for my use case.
>
> However, the total time summaries use numbers of days when the number of
> hours exceeds 24.  Although this is fine most of the time, I would like
> to have total hours instead.  Is this possible?

I found this snippet in the past:

#+BEGIN_SRC elisp :results silent
(setq org-time-clocksum-format '(:hours "%d" :require-hours t :minutes ":%02d" :require-minutes t))
#+END_SRC

[]

> More importantly, the ":formula %" option does not work as soon as days
> appear in the summaries!

With the suggested format it seems to be correct:

#+BEGIN: clocktable :maxlevel 2 :scope file :formula %
#+CAPTION: Clock summary at [2013-09-29 Sun 15:22]
| Headline     | Time    |       |     % |
|--------------+---------+-------+-------|
| *Total time* | *50:03* |       | 100.0 |
|--------------+---------+-------+-------|
| clocking     | 50:03   |       | 100.0 |
| \__ task A   |         | 12:02 |  24.0 |
| \__ task B   |         | 12:51 |  25.7 |
| \__ task C   |         | 25:10 |  50.3 |
#+TBLFM: $4='(org-clock-time% @2$2 $2..$3);%.1f
#+END: clocktable

Regards,
Daniele