emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Aankhen <aankhen@gmail.com>
To: Bernt Hansen <bernt@norang.ca>, Org mailing list <emacs-orgmode@gnu.org>
Subject: Re: Timesheet from clocking data
Date: Fri, 22 Apr 2011 13:39:39 +0530	[thread overview]
Message-ID: <BANLkTina59ToUNgg2ytmxQPi5sfQvWo4TQ@mail.gmail.com> (raw)
In-Reply-To: <87ipu7e0bc.fsf@norang.ca>

Hi Bernt,

On Fri, Apr 22, 2011 at 03:25, Bernt Hansen <bernt@norang.ca> wrote:
> Aankhen <aankhen@gmail.com> 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

      reply	other threads:[~2011-04-22  8:10 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-04-21 20:03 Timesheet from clocking data Aankhen
2011-04-21 21:55 ` Bernt Hansen
2011-04-22  8:09   ` Aankhen [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:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  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=BANLkTina59ToUNgg2ytmxQPi5sfQvWo4TQ@mail.gmail.com \
    --to=aankhen@gmail.com \
    --cc=bernt@norang.ca \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* 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

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

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