[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Table formula not returning an error
From: |
Sebastien Vauban |
Subject: |
[O] Table formula not returning an error |
Date: |
Thu, 06 Oct 2011 16:21:13 +0200 |
User-agent: |
Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (windows-nt) |
Hello,
I was surprised by how 10 minutes was converted to 0.02 hour in a table:
| Tâche | HH:MM | Frac |
|------------+-------+------|
| Avril 2011 | 0:1O | 0.02 |
|------------+-------+------|
| | | 0.02 |
#+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2))
60.);%.2f::@3$3=vsum(@address@hidden)
I took me less than 2 minutes to discover the problem -- wanna play the
"1 diff game" (in the table itself, not in the formula)? -- and fix it:
| Tâche | HH:MM | Frac |
|------------+-------+------|
| Avril 2011 | 0:10 | 0.17 |
|------------+-------+------|
| | | 0.17 |
#+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2))
60.);%.2f::@3$3=vsum(@address@hidden)
But I'm surprised I did not see any error reported.
Best regards,
Seb
--
Sebastien Vauban
- [O] Table formula not returning an error,
Sebastien Vauban <=