emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Matthew Lundin <mdl@imapmail.org>
To: Rainer Hansen <rainer.hansen@gmx.net>
Cc: emacs-orgmode@gnu.org
Subject: Re: Easiest way to calculate time spent
Date: Mon, 06 Apr 2009 16:21:11 -0500	[thread overview]
Message-ID: <m2d4bpjx6g.fsf@fastmail.fm> (raw)
In-Reply-To: <200904062214.38596.rainer.hansen@gmx.net> (Rainer Hansen's message of "Mon\, 6 Apr 2009 22\:14\:38 +0200")

Rainer Hansen <rainer.hansen@gmx.net> 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:


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


      parent reply	other threads:[~2009-04-06 21:21 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2009-04-06 12:35 Easiest way to calculate time spent Rainer Hansen
2009-04-06 17:37 ` Manish
2009-04-06 20:14   ` Rainer Hansen
2009-04-06 21:17     ` Manish
2009-04-06 21:21     ` Matthew Lundin [this message]

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:

  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=m2d4bpjx6g.fsf@fastmail.fm \
    --to=mdl@imapmail.org \
    --cc=emacs-orgmode@gnu.org \
    --cc=rainer.hansen@gmx.net \


* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox


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