[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] [bug] Remote durations are considered as fractions
From: |
Sebastien Vauban |
Subject: |
[O] [bug] Remote durations are considered as fractions |
Date: |
Tue, 03 Apr 2012 14:35:32 +0200 |
User-agent: |
Gnus/5.130004 (Ma Gnus v0.4) Emacs/24.0.94 (windows-nt) |
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
- [O] [bug] Remote durations are considered as fractions,
Sebastien Vauban <=