I have tasks with start and end time. I would like to have a canvas formula that displays Time left.
I’ve come up with a way to combine total duration but it doesn’t take into account that some tasks can run during the same time.
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?
it is an interesting question. My contribution is based on what you provided, but I directly have to add that this approach will be insufficient once we bring into play breaks. To deal with that, we need a different set-up. However first the easy version:
the version with breaks requires an approach that permits us to create various sub lists, thus sub lists for certain periods like morning work, afternoon work etc. It is not very difficult, but a bit more complicated
It seems like it doesn’t take into account the current time.
I should have been more precise from the start… my bad
Would it be possible to alter the formula so that it doesn’t count time in the past?
So if there is a task that started 1 hour in the past goes on for another 1.5 hours in the future, the total duration would = 1.5 hours.
@Fran_Vidicek , most is possible, so far we broke down one barrier (avoiding overlap), the next item is to relate the sum to the remaining ahead. Since you have the max end time, I guess you can figure it out (or somebody else will take it over from here).