From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bernt Hansen Subject: Re: Time computation errors Date: Tue, 07 Apr 2009 11:32:04 -0400 Message-ID: <87d4botr7v.fsf@gollum.intra.norang.ca> References: <87skkktx4n.fsf@gollum.intra.norang.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LrDID-0000q3-Cm for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 11:32:53 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LrDI7-0000kz-Og for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 11:32:51 -0400 Received: from [199.232.76.173] (port=48844 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LrDI7-0000kj-Dr for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 11:32:47 -0400 Received: from blaine.gmane.org ([80.91.229.8]:51564 helo=hugh.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LrDI7-0006Z9-2A for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 11:32:47 -0400 Received: from public by hugh.gmane.org with local (Exim 4.63) (envelope-from ) id 1LrDHj-00058i-Mn for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 17:32:23 +0200 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@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Francesco Pizzolante Cc: mailing-list-org-mode "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? > 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? -Bernt