From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Francesco Pizzolante" Subject: Re: Time computation errors Date: Wed, 08 Apr 2009 08:46:25 +0200 Message-ID: References: <87skkktx4n.fsf@gollum.intra.norang.ca> <87d4botr7v.fsf@gollum.intra.norang.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: In-Reply-To: <87d4botr7v.fsf-EZCVE/ZCkfKiJtKbxSCZYZ53EReGIhmS@public.gmane.org> (Bernt Hansen's message of "Tue, 07 Apr 2009 11:32:04 -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 Bernt Hansen, Bernt Hansen wrote: > "Francesco Pizzolante" > writes: > >>>> 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); > > How do you get negative times by clocking in and out? The only way I > can think of that you can get negative time is if you edit the clocked > values after they are created. By definition you have to clock in > _before_ you clock out (right?) so everything clocked should be 0 > minutes or positive. Am I missing something? Not at all, you're right: you only get negative times when you manually edit your clocks. >> 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? > > I'm not sure what the answer to this is. I use the clocking features to > summarize time spent working on tasks in clock reports only and I've > never had the need to deal with negative values or summing clocked > values manually in a table. > > Maybe other users have experience with summing times in tables outside > of clock reports? On example could be to determine the difference between the estimated effort and the time really spent. You would necessarily end up with negative durations (supposing that some asks took less time than the estimated effort). Does it make sense? Thanks, Francesco _______________________________________________ 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