[Orgmode] Re: [BUG] Table formula with org-hh:mm-string-to-minutes

[Štěpán Němec]

Sébastien Vauban <address@hidden>
writes:

> Hello,
>
> I use the following table and formulas to convert HH:MM times to fractional
> times, so that I can sum up the times (and convert them to money...)
>
> | Task   | *HH:MM* | *Frac* |
> |--------+---------+--------|
> | Item 1 |   20:27 |  20.45 |
> | Item 2 |    2:25 |   2.42 |
> | Item 3 |    2:07 |   2.12 |
> | Item 4 |    0:19 |   0.00 |
> | Item 5 |    0:43 |   0.72 |
> | Item 6 |    0:05 |   0.08 |
> | Item 7 |    0:32 |   0.53 |
> | Item 8 |    0:16 |   0.27 |
> |--------+---------+--------|
> |        |         |  26.59 |
> #+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2))
> 60.);%.2f::@5$3=0.00;%.2f::@10$3=vsum(@address@hidden)

I don't really understand Calc and Org table formulas, but the
"%.2f::@5$3=0.00;" in there looks pretty suspicious, and removing it
fixes it for me. ;-)

Štěpán