Re: [O] [bug] how to specify the format for clock table summaries and bug in formula calculations

[Daniele Pizzolli]

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