From mboxrd@z Thu Jan 1 00:00:00 1970 From: Manish Subject: Re: Easiest way to calculate time spent Date: Mon, 6 Apr 2009 23:07:07 +0530 Message-ID: References: <200904061435.17029.rainer.hansen@gmx.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LqslH-0004Rd-8U for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 13:37:31 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LqslD-0004Q3-26 for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 13:37:30 -0400 Received: from [199.232.76.173] (port=48224 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LqslC-0004Pt-Pg for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 13:37:26 -0400 Received: from ti-out-0910.google.com ([209.85.142.186]:10999) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LqslC-000570-C8 for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 13:37:26 -0400 Received: by ti-out-0910.google.com with SMTP id y8so1865655tia.10 for ; Mon, 06 Apr 2009 10:37:22 -0700 (PDT) In-Reply-To: <200904061435.17029.rainer.hansen@gmx.net> 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: Rainer Hansen Cc: emacs-orgmode@gnu.org On Mon, Apr 6, 2009 at 6:05 PM, Rainer Hansen wrote: > Hi, > > I am new to Org-Mode and I have written a number of project tasks in the > following form: > > * Project > ** Task 1 > <2009-03-19 Thu 13:15-13:35> > Description of Task 1 > ** Task 2 > <2009-03-18 Wed 12:15-13:35> > Description of Task 2 > ** Task 3 > SCHEDULED: <2009-03-11 Wed 19:55-21:45> CLOSED: [2009-03-12 Thu 23:29] > Result of Task 3 > > For task 3 the time calculated should be 2009-03-11 19:55-21:45 that mean 1:50 > hours. > > I have quite a number of items and I wonder if there is an easy way to sum up > all the time spent on the project (similar to what you can do with clocked items)? You mean "time meant to be spent" on the project, right? ;-) Since the actual time spent should be clocked. Anyhow, you can set org-columns-default-format, e.g.: --8<---------------cut here---------------start------------->8--- (setq org-columns-default-format "%TODO %60ITEM(Task) %5Effort(Estim){:} %5CLOCKSUM(Clock)") --8<---------------cut here---------------end--------------->8--- Then switch to column view using C-c C-x C-c. Effort column should reflect the totals for the time you planned to spend on the tasks in the top most line. HTH -- Manish