Sébastien Vauban <wxhgmqzgwmuf-genee64ty+gs+fvcfc7...@public.gmane.org> 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(@-...@-ii) 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 _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
