emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Clocktable :formatter to record time in hours or work-days
@ 2023-04-11 19:11 William Denton
  2023-04-12 12:51 ` Dave Marquardt
  2023-04-12 15:09 ` Dr. Arne Babenhauserheide
  0 siblings, 2 replies; 3+ messages in thread
From: William Denton @ 2023-04-11 19:11 UTC (permalink / raw)
  To: emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 1360 bytes --]

I've been clocking in and out of a project for a few months and now it's over. 
I tagged each entry with "search", so a brief clocktable report looks like this:

#+BEGIN: clocktable :maxlevel 1 :scope file :tags t :match "search"
#+CAPTION: Clock summary at [2023-04-11 Tue 13:48]
| Tags | Headline          |    Time |
|------+-------------------+---------|
|      | Total time        | 4d 6:23 |
|------+-------------------+---------|
|      | 2022-09 September |    0:38 |
|      | 2022-10 October   |    2:46 |
|      | 2022-11 November  |    7:41 |
|      | 2022-12 December  |   10:41 |
|      | 2023-01 January   |   10:16 |
|      | 2023-02 February  | 1d 3:56 |
|      | 2023-03 March     | 1d 3:47 |
|      | 2023-04 April     |   14:38 |
#+END

How could I format the Time column in hours?  How could I format it to hours/8, 
rounded, to represent work-days?  I only want this formatting for this table, I 
have other clocktables in the same file I don't want to change.

I've read about clocktables and the :formatter option, which I assume is what 
will do it, but I can't find any helpful examples so I'm stuck.


Thanks for any help,

Bill

--
William Denton
https://www.miskatonic.org/
Librarian, artist and licensed private investigator.
Toronto, Canada
CO₂: 422.29 ppm (Mauna Loa Observatory, 2023-04-10)

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: Clocktable :formatter to record time in hours or work-days
  2023-04-11 19:11 Clocktable :formatter to record time in hours or work-days William Denton
@ 2023-04-12 12:51 ` Dave Marquardt
  2023-04-12 15:09 ` Dr. Arne Babenhauserheide
  1 sibling, 0 replies; 3+ messages in thread
From: Dave Marquardt @ 2023-04-12 12:51 UTC (permalink / raw)
  To: emacs-orgmode

William Denton <wtd@pobox.com> writes:

> I've been clocking in and out of a project for a few months and now it's over. 
> I tagged each entry with "search", so a brief clocktable report looks like this:
>
> #+BEGIN: clocktable :maxlevel 1 :scope file :tags t :match "search"
> #+CAPTION: Clock summary at [2023-04-11 Tue 13:48]
>
> | Tags | Headline          |    Time |
> |------+-------------------+---------|
> |      | Total time        | 4d 6:23 |
> |------+-------------------+---------|
> |      | 2022-09 September |    0:38 |
> |      | 2022-10 October   |    2:46 |
> |      | 2022-11 November  |    7:41 |
> |      | 2022-12 December  |   10:41 |
> |      | 2023-01 January   |   10:16 |
> |      | 2023-02 February  | 1d 3:56 |
> |      | 2023-03 March     | 1d 3:47 |
> |      | 2023-04 April     |   14:38 |
> #+END
>
> How could I format the Time column in hours?  How could I format it to hours/8, 
> rounded, to represent work-days?  I only want this formatting for this table, I 
> have other clocktables in the same file I don't want to change.
>
> I've read about clocktables and the :formatter option, which I assume is what 
> will do it, but I can't find any helpful examples so I'm stuck.

I just had to rediscovery this recently. Check `org-duration-format`.

-Dave



^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: Clocktable :formatter to record time in hours or work-days
  2023-04-11 19:11 Clocktable :formatter to record time in hours or work-days William Denton
  2023-04-12 12:51 ` Dave Marquardt
@ 2023-04-12 15:09 ` Dr. Arne Babenhauserheide
  1 sibling, 0 replies; 3+ messages in thread
From: Dr. Arne Babenhauserheide @ 2023-04-12 15:09 UTC (permalink / raw)
  To: William Denton; +Cc: emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 531 bytes --]


William Denton <wtd@pobox.com> writes:
> How could I format the Time column in hours?  How could I format it to hours/8, 
> rounded, to represent work-days?  I only want this formatting for this table, I 
> have other clocktables in the same file I don't want to change.

I use the customization '(org-duration-format '((special . h:mm))) but
that would also change other clocktables.

I hope it helps get you started.

Best wishes,
Arne
-- 
Unpolitisch sein
heißt politisch sein,
ohne es zu merken.
draketo.de

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 1125 bytes --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2023-04-12 15:11 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2023-04-11 19:11 Clocktable :formatter to record time in hours or work-days William Denton
2023-04-12 12:51 ` Dave Marquardt
2023-04-12 15:09 ` Dr. Arne Babenhauserheide

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