I’m trying to build myself a time tracker, but I’m finding DateTime a bit tricky to work with. I’d like some pointers, or maybe even a tutorial or guide for working with time in Grist.
For context, I would like to be able to input (pomodoro) work sessions as well as meetings, to be able to see how I spend my time. The work sessions are all 30 minute pomodoro sprints, while meetings are (obviously) of variable length.
I’ve started with the pomodoro sheet, inputting work sessions with beginning time as well as project worked on.
I would like to be able to have Grist automatically calculate the end time as “Start Time + 30 minutes”, but I can’t seem to figure out how to do that - do I have to work with time deltas? I can see the documentation talks about how "DateTime - DateTime = TimeDelta”, but it’s not quite clear to me that “DateTime + TimeDelta = DateTime”, or what the best/correct way to do that is.
I would also like to have a summary sheet that tells me how many pomodoros I have completed on a given day. But when I try making a summary table, I get all the DateTime objects I have in my tracker. In Excel/Google Sheets I can group by date in a Pivot Table, but I can’t figure out how to do that here.
Eventually I would like to make a tracker that shows how much I’ve done per day of the week, per week, per month etc. though that can come later.
Any help would be much appreciated.