Clocktable :formatter to record time in hours or work-days

Clocktable :formatter to record time in hours or work-days

[William Denton]

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

Re: Clocktable :formatter to record time in hours or work-days

[Dave Marquardt]

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

Re: Clocktable :formatter to record time in hours or work-days

[Dr. Arne Babenhauserheide]

[-- 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 --]