Time tracking record export

[igfall]

Hi,
I've been using Day Planner with some enthusiasm. One of the features that I really appreciate but misses some functionality for me, is the time tracking feature. I use a dataview query that summarizes the time I spend on my tasks per day. That works ok, but I find it cumbersome to go through all daily notes at the end of the month to collect the day sums (I wasn't able to update the dataview query in such a way that this would work automatically). Thus I was wondering if there is a feature within the daily planner to collect all tracked time in a single file, cluster it by months and to create an export from that? I could not find anything on this after googling for some time and hope to find an answer here.

Thanks for the help and cheers!

[igfall]

Hi again,

I put together a little query form hell (excuse my coding...) that does the job for me. One thing I can not figure out is how to sort it by latest entry first.

This query takes your taks that you have put under your Day Planner "Planner Heading Text" in the daily notes (my folder is 01-Journal/01-Daily, yours will for sure differ and you have to chang the in the query).
If you clock in and out of that task, you can generate a monthly overview of the spent time if you put this query in a note of your convenience. The result is a table that lists the collected tasks for a month and groups them together, next to it it shows the start and end dates as well as times. All gets summed up and put as overall minutes and overall time spent in "hh:mm" format.

I want to reiterate, this works for me at the time and I hope someone else finds it useful. If you have improvements for the code please let me know.

Cheers

table without id rows.Task as "Day Entries", rows.StartDay as "Start Day",rows.EndDay as "End Day", rows.Start as "Start",  rows.End as "End", rows.timeSpent as "Duration",  sum(rows.Minutes) as "Month Sum (mm)",  durationformat(dur(sum(rows.Minutes)+"minutes"),"hh':'mm") AS "Month Sum (hh:mm)"
FROM "01-Journal/01-Daily" 
FLATTEN file.tasks AS t where nonnull(t.clock) AND !children
FLATTEN split(t.text, "\n")[0] AS Task
FLATTEN t.clock AS timeRange
FLATTEN dateformat(date(split(timeRange,"T")[0]),"yyyy-MM-dd") as StartDay
FLATTEN dateformat(date(split(timeRange,"--")[1]),"yyyy-MM-dd") as EndDay
FLATTEN dateformat(date(split(timeRange,"--")[0]),"HH':'mm") as Start
FLATTEN dateformat(date(split(timeRange,"--")[1]),"HH':'mm") as End
FLATTEN durationformat(dur(date(split(timeRange,"--")[1]) - date(split(timeRange,"--")[0])), "hh':'mm") AS timeSpent 
FLATTEN ceil(dur(date(split(timeRange,"--")[1]) - date(split(timeRange,"--")[0])).minutes) AS Minutes
SORT file.ctime ASC
GROUP BY file.ctime.month AS Month