emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* [bug] Remote durations are considered as fractions
@ 2012-04-03 12:35 Sebastien Vauban
  2012-04-10 22:46 ` Bastien
  0 siblings, 1 reply; 9+ messages in thread
From: Sebastien Vauban @ 2012-04-03 12:35 UTC (permalink / raw)
  To: emacs-orgmode-mXXj517/zsQ

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

^ permalink raw reply	[flat|nested] 9+ messages in thread

end of thread, other threads:[~2012-06-04 15:02 UTC | newest]

Thread overview: 9+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2012-04-03 12:35 [bug] Remote durations are considered as fractions Sebastien Vauban
2012-04-10 22:46 ` 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

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