From: "Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org
Subject: [bug] Remote durations are considered as fractions
Date: Tue, 03 Apr 2012 14:35:32 +0200 [thread overview]
Message-ID: <80mx6t2dt7.fsf@somewhere.org> (raw)
Hello,
It took me a while to understand what was going on with some figures in tables
derived from a clock report, but I found it: computed total times, referred in
a table, are converted as fractions, that is...
- 3:36 becomes 1:12 (because 3/36 = 1/12)
- 0:51 becomes 0
- 9:03 becomes 3
- 3:34 stays 3:34...
Example:
* Hours spent
#+tblname: hours-spent
#+BEGIN: clocktable :maxlevel 4 :scope ("file-tom.org") :block 2012-04 :indent t
Clock summary at [2012-04-03 Tue 14:30], for April 2012.
| File | Headline | Time | | |
|--------------+-----------------------------------+-------+------+------|
| | ALL Total time | 18:45 | | |
|--------------+-----------------------------------+-------+------+------|
| file-tom.org | File time | 12:39 | | |
| | Planning | | 3:36 | |
| | \__ TODO Arrange meetings | | | 0:51 |
| | \__ TODO List skills required | | | 1:27 |
| | \__ TODO Organize interviews | | | 1:18 |
| | Reporting | | 9:03 | |
| | \__ TODO Make report | | | 6:47 |
| | \__ TODO Present report | | | 2:16 |
#+END:
* Summary
Time worked on some projects is wrong:
| Planning | 1:12 |
| Reporting | 3 |
#+TBLFM: @1$2=remote(hours-spent,@4$4)::@2$2=remote(hours-spent,@8$4)
Using the flag T does not help:
| Planning | 00:00:03 |
| Reporting | 00:00:09 |
#+TBLFM: @1$2=remote(hours-spent,@4$4);T::@2$2=remote(hours-spent,@8$4);T
Using the flag t does not help either:
| Planning | 0.00 |
| Reporting | 0.00 |
#+TBLFM: @1$2=remote(hours-spent,@4$4);t::@2$2=remote(hours-spent,@8$4);t
Best regards,
Seb
PS- BTW, this is a nice "clock table" where totals are not mixed. I sent two
posts yesterday, but did not see them yet on Gmane -- my NNTP source.
--
Sebastien Vauban
next reply other threads:[~2012-04-03 12:35 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-04-03 12:35 Sebastien Vauban [this message]
2012-04-10 22:46 ` [bug] Remote durations are considered as fractions Bastien
2012-04-19 13:19 ` Sebastien Vauban
2012-04-20 11:21 ` Bastien
2012-04-20 20:45 ` Sebastien Vauban
2012-04-20 23:22 ` Bastien
2012-05-02 10:32 ` Sebastien Vauban
2012-05-09 19:16 ` Sebastien Vauban
2012-06-04 15:02 ` Sebastien Vauban
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=80mx6t2dt7.fsf@somewhere.org \
--to=wxhgmqzgwmuf-genee64ty+gs+fvcfc7uqw@public.gmane.org \
--cc=emacs-orgmode-mXXj517/zsQ@public.gmane.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
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).