From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matthew Lundin Subject: Re: Easiest way to calculate time spent Date: Mon, 06 Apr 2009 16:21:11 -0500 Message-ID: References: <200904061435.17029.rainer.hansen@gmx.net> <200904062214.38596.rainer.hansen@gmx.net> 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 1LqwFs-0003wX-F7 for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 17:21:20 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LqwFn-0003wL-0x for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 17:21:19 -0400 Received: from [199.232.76.173] (port=60176 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LqwFm-0003wI-Ta for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 17:21:14 -0400 Received: from out2.smtp.messagingengine.com ([66.111.4.26]:40532) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LqwFm-0002hL-Lq for emacs-orgmode@gnu.org; Mon, 06 Apr 2009 17:21:14 -0400 In-Reply-To: <200904062214.38596.rainer.hansen@gmx.net> (Rainer Hansen's message of "Mon\, 6 Apr 2009 22\:14\:38 +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: Rainer Hansen Cc: emacs-orgmode@gnu.org Rainer Hansen writes: > 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. Unless you enter your clocked time as a property, org columns will not be able to do anything with it. Your best bet, however, would be to use org-mode's excellent clocking functionality (see description below). >> > 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)? What you have done above is scheduled the tasks to occupy certain time intervals in your agenda/planner. E.g., Task 1 is scheduled on March 11 from 19:55 to 21:45. This is *not* the same thing as clocking time spent working on an item. As far as I know, org-mode cannot calculate time totals based on the SCHEDULED timestamps. To log items you will need to clock in on a headling using C-c C-x C-i and clock out using C-c C-x C-o. Org mode will then create a clock line listing starting time, ending time, and total time spent. See this section of the manual for more information: http://orgmode.org/org.html#Clocking-work-time >> 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--- >> The clocksum in Manish's example will add the the total time logged via the method I have described above. Estimated effort is a special property that you would need to enter yourself for each item. (But it sounds as if you are not really interested in that.) Hope this helps. Matt