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(@-I..@-II)

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(@-I..@-II)

But I'm surprised I did not see any error reported.

Best regards,
  Seb

-- 
Sebastien Vauban


Reply via email to