[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] Re: [BUG] Table formula with org-hh:mm-string-to-minutes
From: |
Sébastien Vauban |
Subject: |
[Orgmode] Re: [BUG] Table formula with org-hh:mm-string-to-minutes |
Date: |
Wed, 06 Oct 2010 10:03:52 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) |
Hi Achim, Štěpán and Carsten,
Achim Gratz wrote:
> [repost -- sorry if this turns out a duplicate]
>
> Sébastien Vauban <address@hidden>
> 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=0.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 cell,
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
--
Sébastien Vauban