From mboxrd@z Thu Jan  1 00:00:00 1970
From: Bernt Hansen <bernt@norang.ca>
Subject: Re: Time computation errors
Date: Tue, 07 Apr 2009 09:24:24 -0400
Message-ID: <87skkktx4n.fsf@gollum.intra.norang.ca>
References: <u63hg62rd.fsf@missioncriticalit.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1LrBIW-0002aK-H0
	for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 09:25:04 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1LrBIR-0002Z2-QO
	for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 09:25:04 -0400
Received: from [199.232.76.173] (port=49536 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1LrBIR-0002Yz-Nt
	for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 09:24:59 -0400
Received: from blaine.gmane.org ([80.91.229.8]:58303 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 <public@hugh.gmane.org>)
	id 1LrBIR-0002be-68
	for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 09:24:59 -0400
Received: from public by hugh.gmane.org with local (Exim 4.63)
	(envelope-from <public@hugh.gmane.org>) id 1LrBIK-0004rU-U2
	for emacs-orgmode@gnu.org; Tue, 07 Apr 2009 15:24:52 +0200
In-Reply-To: <u63hg62rd.fsf@missioncriticalit.com> (Francesco Pizzolante's
	message of "Tue\, 07 Apr 2009 14\:29\:21 +0200")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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 <public-fpz-djc/iPCCuDYQheJpep6IedvLeJWuRmrY@hugh.gmane.org>
Cc: mailing-list-org-mode <public-emacs-orgmode-mXXj517/zsQ@hugh.gmane.org>



"Francesco Pizzolante"
<fpz-djc/iPCCuDYQheJpep6IedvLeJWuRmrY@public.gmane.org> writes:

> 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.

-Bernt