Re: [O] Timesheet from clocking data

[Aankhen]

Hi Bernt,

On Fri, Apr 22, 2011 at 03:25, Bernt Hansen <address@hidden> wrote:
> Aankhen <address@hidden> writes:
>
>> Greetings,
>>
>> Given an Org file with clocking data, is there a way to generate a
>> timesheet?  This would complement the clock table by focusing on the
>> timings rather than the headings.
>>
>> As I haven’t come across anything like this as yet, I’ll try to give
>> an example (manually-created) to show what I mean, in case someone
>> more familiar with Org can tell me something about it:
>>
>> ,----[ Org tree ]
>> | * Foo
>> |   :CLOCK:
>> |   CLOCK: [2011-04-19 Tue 18:50]--[2011-04-19 Tue 20:30] =>  1:40
>> |   CLOCK: [2011-04-18 Mon 20:15]--[2011-04-18 Mon 21:00] =>  0:45
>> |   CLOCK: [2011-04-21 Thu 01:03]--[2011-04-21 Thu 02:03] =>  1:00
>> |   :END:
>> |   CLOCK: [2011-04-19 Tue 12:30]--[2011-04-19 Tue 18:06] =>  5:36
>> |
>> |
>> | *** Bar
>> |     :CLOCK:
>> |     CLOCK: [2011-04-19 Tue 18:06]--[2011-04-19 Tue 18:50] =>  0:44
>> |     CLOCK: [2011-04-22 Fri 01:00]--[2011-04-22 Fri 01:05] =>  0:05
>> |     :END:
>> |
>> | *** Baz
>> |     :CLOCK:
>> |     CLOCK: [2011-04-21 Thu 03:10]--[2011-04-21 Thu 04:00] =>  0:50
>> |     :END:
>> `----
>>
>> [snip]
>
> Hi Aankhen,
>
> There is no functionality that produces the table in your timesheet
> example that I am aware of.  Personally I use the agenda view with log
> mode enabled for clock lines and limited to some interesting tags and a
> summary report with C-u R.  I then manually transfer the data to another
> system for timesheet reporting.  I just visit each day in the timesheet
> range to get the details I want.
>
> You can generate daily reports with something like this
>
> #+BEGIN: clocktable :maxlevel 2 :scope agenda :fileskip0 t :step day :block 
> thisweek
> #+END:
>
> which gives a separate table per day but it doesn't include the time
> details.

I see, thank you for the answer.  I might end up using a second system
for this too, this time.  Maybe I’ll try writing something to produce
these tables in a few days, by hacking together bits from the clock
table.

Aankhen