emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Manish <mailtomanish.sharma@gmail.com>
To: Rainer Hansen <rainer.hansen@gmx.net>
Cc: emacs-orgmode@gnu.org
Subject: Re: Easiest way to calculate time spent
Date: Tue, 7 Apr 2009 02:47:05 +0530	[thread overview]
Message-ID: <e7cdbe30904061417y430884a3k71e7bdec031ddfb6@mail.gmail.com> (raw)
In-Reply-To: <200904062214.38596.rainer.hansen@gmx.net>

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

  On Tue, Apr 7, 2009 at 1:44 AM, Rainer Hansen wrote:
  > 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.

Unless the values are in the format that Org uses to clock time spent on tasks
it will not be able to process it.  In future you can start and stop the clock
with point on the task and pressing C-c C-x C-i and C-c C-x C-o respectively
while in Org file or using I and O while in agenda view.  See
http://orgmode.org/manual/Clocking-work-time.html#Clocking-work-time for

Since you have already worked and noted the times, you will again have to do
some more manual work to get what you want from Org.  You will need to add a
LOGBOOK drawer beneath every task you want to record time for - you can either
copy-paste or can try C-c C-x p to add the drawer.  Then you can add the time
periods like shown below.  A quick way would be to just clock in and out of
task so as to get clock lines there and either manually edit the times or use
magical Shift-up or Shift-down to adjust the clock lines.  You can press C-c
C-y on the clock line in case you manually edit the time to recompute the

| * A Task
|   CLOCK: [2009-04-07 Tue 02:30]--[2009-04-07 Tue 03:00] =>  0:30
|   CLOCK: [2009-04-07 Tue 01:00]--[2009-04-07 Tue 02:00] =>  1:00
|   :END:

Once you have clocked times like this then you can get the total for the time
spent under CLOCKSUM column in column view or you can get a report in the
agenda file itself with clocktable report (C-c C-x C-r).


  reply	other threads:[~2009-04-06 21:17 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 [this message]
2009-04-06 21:21     ` Matthew Lundin

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=e7cdbe30904061417y430884a3k71e7bdec031ddfb6@mail.gmail.com \
    --to=mailtomanish.sharma@gmail.com \
    --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).