From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?S=C3=A9bastien_Vauban?= Subject: Re: [BUG] Table formula with org-hh:mm-string-to-minutes Date: Wed, 06 Oct 2010 10:03:52 +0200 Message-ID: <8739sjlpcn.fsf@mundaneum.com> References: <87fwwkyc46.fsf@mundaneum.com> <87mxqsjvyw.fsf@Rainer.invalid> 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 Hi Achim, =C5=A0t=C4=9Bp=C3=A1n and Carsten, Achim Gratz wrote: > [repost -- sorry if this turns out a duplicate] > > S=C3=A9bastien Vauban > writes: >> Everything is fine... but the item 4: 19 minutes get converted to 0.00 >> hour... Why!? > > Because you told it to: remove ";%.2f::@5$3=3D0.00" from the formula and = live > a happier life. Sorry. Stupid from me. Copy/paste of a similar table, but with one difference... That proves that I have to use another -- more explicit way -- to void a ce= ll, by using a SUMIF construct, and having a 0/1 value somewhere else. There has been a thread on such a thing a couple of weeks ago... Thanks for your quick answer. 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