Logging is quick and easy. I spend 1 minute at the end of each workday to log what I did that day.
Extracting logged time
library(tidyverse)library(clockify)# Set up your API access first (not shown).timelog <- clockify::reports_detailed("2026-01-01", "2026-01-31")timelog |>select(-user_id)
I store the raw and cleaned timelogs aggregated to each month.
Creating reports
Load the timelogs for the months you want from storage
Merge them
Do date calculations on them and summarise on whatever you want to know
1. Am I working too much or too little?
give_overtime(all_time)
For the period: 2023-05-01 UTC--2025-12-31 UTC
Contract hours: 5235
Offhours: 645.5
Should have worked: 4589.5
Worked hours: 4635.83333333333
Overtime status: 46.3333333333339
Note: Positive hours means you worked more than expected, negative means you worked less.
I worked more than I should!
Hooray?
2. What am I spending my time on?
2024
Work allocation
Against intended workload
Project
Total hours
%
Intended %
Admin work
56.50
3.11
6
Research and development
737.75
40.55
47
Teaching
1025.25
56.35
47
Period: 2024-01-01 UTC--2024-12-31 UTC
2025
Work allocation
Against intended workload
Project
Total hours
%
Intended %
Admin work
12.00
0.85
6
Research and development
733.75
51.91
47
Teaching
667.75
47.24
47
Period: 2025-01-01 UTC--2025-10-31 UTC
Concluding thoughts
Time is difficult
How many days are in the interval Jan 1st to Jan 31st? Technically 30 days.
