From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Francesco Pizzolante" Subject: Re: Time computation errors Date: Tue, 07 Apr 2009 16:12:23 +0200 Message-ID: References: <87skkktx4n.fsf@gollum.intra.norang.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: In-Reply-To: <87skkktx4n.fsf-EZCVE/ZCkfKiJtKbxSCZYZ53EReGIhmS@public.gmane.org> (Bernt Hansen's message of "Tue, 07 Apr 2009 09:24:24 -0400") 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: mailing-list-org-mode Hi Bernt, Thanks for your answer. >> Consider the following example: >> >> --8<---------------cut here---------------start------------->8--- >> * Test >> #+COLUMNS: %25ITEM(Description) %Time1{:} %Time2{:} %Time3{:} >> >> #+BEGIN: columnview :hlines 1 :id local >> | Description | Time1 | Time2 | Time3 | >> |-------------+-------+-------+--------| >> | * Test | 3:30 | 3:00 | #ERROR | >> | *** Item 1 | -1:30 | 1:00 | #ERROR | >> | *** Item 2 | 4:00 | 2:00 | #ERROR | >> #+TBLFM: $4=$2+$3 >> #+END: >> >> *** Item 1 >> :PROPERTIES: >> :Time1: -1:30 >> :Time2: 1:00 >> :END: >> >> *** Item 2 >> :PROPERTIES: >> :Time1: 4:00 >> :Time2: 2:00 >> :END: >> --8<---------------cut here---------------end--------------->8--- >> >> >> Problems: >> >> 1) The sum of Time1 for Test headline is wrong: 3:30 instead of >> 2:30; >> >> 2) I'm unable to sum times through a formula (see Time3 column). >> The same formula works perfectly when you replace times with >> integers. >> >> Any feedback is welcome. > > I don't believe negative times are supported currently. You are probably right. The fact is that: 1) when you clock in and out, you can get negative durations (I know, it seems weird...) and then your clock table is wrong (negative duration are not taken into account when calculating the sums). Anyway, I think it should be good to support negative durations in order, for example, to compute differences between durations (which can lead to positive or negative times); 2) I'm still unable to sum positive times value in my table (see my problem 2) in my previous email). Is there a specific operator in order to sum times? Thanks, F. _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode-mXXj517/zsQ@public.gmane.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode