From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?S=C3=A9bastien_Vauban?= Subject: [BUG] Table formula with org-hh:mm-string-to-minutes Date: Tue, 05 Oct 2010 15:59:05 +0200 Message-ID: <87fwwkyc46.fsf@mundaneum.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org 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=3D'(/ (float (org-hh:mm-string-to-minutes $2)) 60.);%.2f::@5$3= =3D0.00;%.2f::@10$3=3Dvsum(@-I..@-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 su= ch, as 0:05 is well converted (to 0.08 hour). Do you have a hint? Best regards, Seb --=20 S=C3=A9bastien Vauban _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode-mXXj517/zsQ@public.gmane.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode