Member-only story
How to Coda breaks between periods?
when your tasks have overlap and you need periods
In the community I contributed by partly responding to:
I have tasks with start and end time. I would like to have a canvas formula that displays Time left.
How do I subtract that time so that 1 minute of real time can only count as one minute, instead of 2, if for example there are 2 tasks running at the same time?
In this blog I deal with one aspect of this question: getting the periods and their duration uniquely based on start & end time. The translation to the canvas and the countdown I put aside here.
We start simple and look at a period without breaks. To solve this matter we first need to know the total duration of the consecutive tasks. We first create a list of unique time start & end times and we order them. We asks for all items in the list and thus we use thisTable
Based on this list we ask for the duration of each period:
