emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Eric S Fraga <e.fraga@ucl.ac.uk>
To: emacs-orgmode@gnu.org
Subject: [bug] how to specify the format for clock table summaries and bug in formula calculations
Date: Sun, 29 Sep 2013 13:33:11 +0100	[thread overview]
Message-ID: <87ioxjbyew.fsf@ucl.ac.uk> (raw)

[-- Attachment #1: Type: text/plain, Size: 830 bytes --]

Hello,

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?

More importantly, the ":formula %" option does not work as soon as days
appear in the summaries!  The calculations for the percentages use only
the hours in the totals, regardless of the number of days leading to
some very interesting results (percentages > 100).  I don't know enough
emacs calc to start to suggest how this could be fixed
unfortunately... :(

ECM attached.

Any pointers appreciated! 

Thanks, 
eric

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 24.3.50.1, Org release_8.2-20-gc5f370

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: clocking.org --]
[-- Type: text/x-org, Size: 1066 bytes --]

* clocking
** task A
CLOCK: [2013-09-21 Sat 12:00]--[2013-09-21 Sat 18:00] =>  6:00
CLOCK: [2013-09-19 Thu 14:49]--[2013-09-19 Thu 17:50] =>  3:01
CLOCK: [2013-09-19 Thu 08:49]--[2013-09-19 Thu 11:50] =>  3:01
** task B
CLOCK: [2013-09-20 Fri 08:49]--[2013-09-20 Fri 18:50] => 10:01
CLOCK: [2013-09-19 Thu 11:50]--[2013-09-19 Thu 14:40] =>  2:50
** task C
CLOCK: [2013-09-18 Wed 08:00]--[2013-09-18 Wed 14:50] =>  6:50
CLOCK: [2013-09-17 Tue 08:35]--[2013-09-17 Tue 18:50] => 10:15
CLOCK: [2013-09-16 Mon 08:45]--[2013-09-16 Mon 16:50] =>  8:05
** Summary
#+BEGIN: clocktable :maxlevel 2 :scope file :formula %
#+CAPTION: Clock summary at [2013-09-29 Sun 13:29]
| Headline   | Time    |         |     % |
|------------+---------+---------+-------|
| *Total time* | *2d 2:03* |         | 100.0 |
|------------+---------+---------+-------|
| clocking   | 2d 2:03 |         | 100.0 |
| \__ task A |         |   12:02 | 587.0 |
| \__ task B |         |   12:51 | 626.8 |
| \__ task C |         | 1d 1:10 |  56.9 |
#+TBLFM: $4='(org-clock-time% @2$2 $2..$3);%.1f
#+END:

next             reply	other threads:[~2013-09-29 12:33 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2013-09-29 12:33 Eric S Fraga [this message]
2013-09-29 13:21 ` [bug] how to specify the format for clock table summaries and bug in formula calculations Carsten Dominik
2013-09-30 11:38   ` Eric S Fraga
2013-09-29 13:24 ` Daniele Pizzolli
2013-09-30 11:38   ` Eric S Fraga

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87ioxjbyew.fsf@ucl.ac.uk \
    --to=e.fraga@ucl.ac.uk \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).