Table formula not returning an error

Table formula not returning an error

[Sebastien Vauban]

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

Re: Table formula not returning an error

[Lawrence Mitchell]

Sebastien Vauban wrote:

[...]

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

This is a feature of org-hh:mm-string-to-minutes:

| Convert a string H:MM to a number of minutes.
| If the string is just a number, interpret it as minutes.
| In fact, the first hh:mm or number in the string will be taken,
| there can be extra stuff in the string.
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| If no number is found, the return value is 0.

It's arguable that this is the best choice, but it is one.

Lawrence
-- 
Lawrence Mitchell <wence@gmx.li>