emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
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

             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).