From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" Subject: Table formula not returning an error Date: Thu, 06 Oct 2011 16:21:13 +0200 Message-ID: <80mxdeciau.fsf@somewhere.org> 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: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hello, I was surprised by how 10 minutes was converted to 0.02 hour in a table: | T=C3=A2che | HH:MM | Frac | |------------+-------+------| | Avril 2011 | 0:1O | 0.02 | |------------+-------+------| | | | 0.02 | #+TBLFM: $3=3D'(/ (float (org-hh:mm-string-to-minutes $2)) 60.);%.2f::@3$3= =3Dvsum(@-I..@-II) I took me less than 2 minutes to discover the problem -- wanna play the "1=C2=A0diff game" (in the table itself, not in the formula)? -- and fix it: | T=C3=A2che | HH:MM | Frac | |------------+-------+------| | Avril 2011 | 0:10 | 0.17 | |------------+-------+------| | | | 0.17 | #+TBLFM: $3=3D'(/ (float (org-hh:mm-string-to-minutes $2)) 60.);%.2f::@3$3= =3Dvsum(@-I..@-II) But I'm surprised I did not see any error reported. Best regards, Seb --=20 Sebastien Vauban