Re: Easiest way to calculate time spent

[Rainer Hansen <rainer.hansen@gmx.net>]

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