From mboxrd@z Thu Jan 1 00:00:00 1970 From: ConcreteVitamin Subject: How to generate clock report for hours worked each day? Date: Sat, 23 Sep 2017 20:51:57 +0000 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="94eb2c1fd5ecb79d730559e17f54" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50726) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dvrPI-0003P6-MN for emacs-orgmode@gnu.org; Sat, 23 Sep 2017 16:52:13 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dvrPH-000661-Qk for emacs-orgmode@gnu.org; Sat, 23 Sep 2017 16:52:12 -0400 Received: from mail-it0-x233.google.com ([2607:f8b0:4001:c0b::233]:56166) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dvrPH-000648-D8 for emacs-orgmode@gnu.org; Sat, 23 Sep 2017 16:52:11 -0400 Received: by mail-it0-x233.google.com with SMTP id 4so3879686itv.4 for ; Sat, 23 Sep 2017 13:52:09 -0700 (PDT) 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" To: emacs-orgmode@gnu.org --94eb2c1fd5ecb79d730559e17f54 Content-Type: text/plain; charset="UTF-8" org-clock-report is awesome; however, it reports time spent on each task. Is there any custom command that you use to generate a clock report *showing hours worked, across tasks, for each day*? The trouble I've encountered is that, I file my TODO captures under a file+datetree entry. For example, one TODO task might be filed on Day -2, but I could be working on it -- i.e., clocking in and out -- on Day -2, -1, and today. So generating a table naively will just show something like: #+BEGIN: clocktable :maxlevel 4 :scope file :block thisweek #+CAPTION: Clock summary at [2017-09-23 Sat 11:48], for week 2017-W38. | Headline | Time | | | | |---------------------------------------+-----------+---------+-------+-------| | *Total time* | *1d 0:12* | | | | |---------------------------------------+-----------+---------+-------+-------| | 2017 | 1d 0:12 | | | | | \_ 2017-09 September | | 1d 0:12 | | | | \_ 2017-09-11 Monday | | | 1:23 | | | \_ look into AAA BBBB project | | | | | \_ 2017-09-15 Friday | | | 3:33 | | | \_ look into XXX YYYY project | | | | 3:33 | #+END: Note that the second TODO task was filed under 2017-09-15 Friday, which was the date I entered the task. But really, I might have worked on it on Friday, Saturday, etc. I just want another command to show how many hours I've worked on each day, generating a report such as the following: 2017-09-11 Monday xx hours yy mins worked (across all tasks) ... 2017-09-15 Friday zz hours tt mins worked (across all tasks) Thanks in advance. --94eb2c1fd5ecb79d730559e17f54 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

org-clock-report= =C2=A0is awesome; however, it reports time spent on each task. Is there any= custom command that you use to generate a clock report=C2=A0showing hours worked, across tasks, for eac= h day?

The trouble I've= encountered is that, I file my TODO captures under a=C2=A0file+datetree=C2=A0entry. For example, one TODO task might be filed on Day -2, but I = could be working on it -- i.e., clocking in and out -- on Day -2, -1, and t= oday. So generating a table naively will just show something like:

#+BEGIN: clocktab=
le :maxlevel 4 :scope file :block thisweek=20
#+CAPTION: Clock summary at [2017-09-23 Sat 11:48], for week 2017-W38.
| Headline                              | Time      |         |       |    =
   |
|---------------------------------------+-----------+---------+-------+----=
---|
| *Total time*                          | *1d 0:12* |         |       |    =
   |
|---------------------------------------+-----------+---------+-------+----=
---|
| 2017                                  | 1d 0:12   |         |       |    =
   |
| \_  2017-09 September                 |           | 1d 0:12 |       |    =
   |
| \_    2017-09-11 Monday               |           |         |  1:23 |    =
   |
| \_      look into AAA BBBB project    |           |         |       | =20
| \_    2017-09-15 Friday               |           |         |  3:33 |    =
   |
| \_      look into XXX YYYY project    |           |         |       |  3:=
33 |
#+END:

Note that the second TODO = task was filed under=C2=A02017-09-15 Friday, which was the date I ent= ered the task. But really, I might have worked on it on Friday, Saturday, e= tc. I just want another command to show how many hours I've worked on e= ach day, generating a report such as the following:

2017-09-11 Monday     xx hours y=
y mins worked (across all tasks)
...
2017-09-15 Friday     zz hours tt mins worked (across all tasks)

Thanks in advance.

--94eb2c1fd5ecb79d730559e17f54--