emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: "Francesco Pizzolante" <fpz-djc/iPCCuDYQheJpep6IedvLeJWuRmrY@public.gmane.org>
To: mailing-list-org-mode <emacs-orgmode-mXXj517/zsQ@public.gmane.org>
Subject: Re: Time computation errors
Date: Tue, 07 Apr 2009 16:12:23 +0200	[thread overview]
Message-ID: <u7i1w4koo.fsf@missioncriticalit.com> (raw)
In-Reply-To: <87skkktx4n.fsf-EZCVE/ZCkfKiJtKbxSCZYZ53EReGIhmS@public.gmane.org> (Bernt Hansen's message of "Tue, 07 Apr 2009 09:24:24 -0400")

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

  parent reply	other threads:[~2009-04-07 14:12 UTC|newest]

Thread overview: 7+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2009-04-07 12:29 Francesco Pizzolante
2009-04-07 13:24 ` Bernt Hansen
     [not found]   ` <87skkktx4n.fsf-EZCVE/ZCkfKiJtKbxSCZYZ53EReGIhmS@public.gmane.org>
2009-04-07 14:12     ` Francesco Pizzolante [this message]
2009-04-07 15:32       ` Bernt Hansen
     [not found]         ` <87d4botr7v.fsf-EZCVE/ZCkfKiJtKbxSCZYZ53EReGIhmS@public.gmane.org>
2009-04-08  6:46           ` Francesco Pizzolante
2009-04-08 14:48             ` Bernt Hansen
2009-04-07 22:37 ` Daniel Clemente

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=u7i1w4koo.fsf@missioncriticalit.com \
    --to=fpz-djc/ipccudyqhejpep6iedvlejwurmry@public.gmane.org \
    --cc=emacs-orgmode-mXXj517/zsQ@public.gmane.org \
    --subject='Re: Time computation errors' \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this inbox:

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).