From mboxrd@z Thu Jan 1 00:00:00 1970 From: Rainer Hansen Subject: Re: Easiest way to calculate time spent Date: Mon, 6 Apr 2009 22:14:38 +0200 Message-ID: <200904062214.38596.rainer.hansen@gmx.net> 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 1LqvDU-000269-JD for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 16:14:48 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LqvDO-0001zJ-TZ for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 16:14:47 -0400 Received: from [199.232.76.173] (port=43498 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LqvDO-0001z7-Oi for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 16:14:42 -0400 Received: from mail.gmx.net ([213.165.64.20]:49031) by monty-python.gnu.org with smtp (Exim 4.60) (envelope-from ) id 1LqvDO-0008G5-7d for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 16:14:42 -0400 In-Reply-To: Content-Disposition: inline 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: Manish Cc: emacs-orgmode@gnu.org Hi Manish, thanks for the tip but it does not seem to work. All columns seem to be filled with values except of the Estim colum. There are no values displayed. I have done the clocking manually without the help of Org-Mode. The values in my case are actually no estimates but rather the clocked values. Now I want to sum them up to see how many hours I have spent on the project. Regards, Rainer On Monday 06 April 2009 19:37:07 Manish wrote: > 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