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) Everything is fine... but the item 4: 19 minutes get converted to 0.00 hour... Why!? It's not even because it's a small figure that would be rounded, or some such, as 0:05 is well converted (to 0.08 hour). Do you have a hint? Best regards, Seb -- Sébastien Vauban _______________________________________________ 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
