From mboxrd@z Thu Jan 1 00:00:00 1970 From: Aankhen Subject: Re: Timesheet from clocking data Date: Fri, 22 Apr 2011 13:39:39 +0530 Message-ID: References: <87ipu7e0bc.fsf@norang.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:50823) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QDBRQ-0007Ck-CW for emacs-orgmode@gnu.org; Fri, 22 Apr 2011 04:10:17 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QDBRP-0004fg-69 for emacs-orgmode@gnu.org; Fri, 22 Apr 2011 04:10:16 -0400 Received: from mail-vx0-f169.google.com ([209.85.220.169]:55747) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QDBRP-0004fc-3o for emacs-orgmode@gnu.org; Fri, 22 Apr 2011 04:10:15 -0400 Received: by vxk20 with SMTP id 20so442292vxk.0 for ; Fri, 22 Apr 2011 01:10:14 -0700 (PDT) In-Reply-To: <87ipu7e0bc.fsf@norang.ca> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Bernt Hansen , Org mailing list Hi Bernt, On Fri, Apr 22, 2011 at 03:25, Bernt Hansen wrote: > Aankhen writes: > >> Greetings, >> >> Given an Org file with clocking data, is there a way to generate a >> timesheet? =C2=A0This would complement the clock table by focusing on th= e >> timings rather than the headings. >> >> As I haven=E2=80=99t come across anything like this as yet, I=E2=80=99ll= 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 >> | =C2=A0 :CLOCK: >> | =C2=A0 CLOCK: [2011-04-19 Tue 18:50]--[2011-04-19 Tue 20:30] =3D> =C2= =A01:40 >> | =C2=A0 CLOCK: [2011-04-18 Mon 20:15]--[2011-04-18 Mon 21:00] =3D> =C2= =A00:45 >> | =C2=A0 CLOCK: [2011-04-21 Thu 01:03]--[2011-04-21 Thu 02:03] =3D> =C2= =A01:00 >> | =C2=A0 :END: >> | =C2=A0 CLOCK: [2011-04-19 Tue 12:30]--[2011-04-19 Tue 18:06] =3D> =C2= =A05:36 >> | >> | >> | *** Bar >> | =C2=A0 =C2=A0 :CLOCK: >> | =C2=A0 =C2=A0 CLOCK: [2011-04-19 Tue 18:06]--[2011-04-19 Tue 18:50] = =3D> =C2=A00:44 >> | =C2=A0 =C2=A0 CLOCK: [2011-04-22 Fri 01:00]--[2011-04-22 Fri 01:05] = =3D> =C2=A00:05 >> | =C2=A0 =C2=A0 :END: >> | >> | *** Baz >> | =C2=A0 =C2=A0 :CLOCK: >> | =C2=A0 =C2=A0 CLOCK: [2011-04-21 Thu 03:10]--[2011-04-21 Thu 04:00] = =3D> =C2=A00:50 >> | =C2=A0 =C2=A0 :END: >> `---- >> >> [snip] > > Hi Aankhen, > > There is no functionality that produces the table in your timesheet > example that I am aware of. =C2=A0Personally I use the agenda view with l= og > mode enabled for clock lines and limited to some interesting tags and a > summary report with C-u R. =C2=A0I then manually transfer the data to ano= ther > system for timesheet reporting. =C2=A0I just visit each day in the timesh= eet > 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 :blo= ck 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=E2=80=99ll try writing something to produ= ce these tables in a few days, by hacking together bits from the clock table. Aankhen