A super simple task time tracker / stopwatch that supports pausing the timer. Done in a single table; leverages Coda’s capability to store lists of values in a cell.
Can be handy if you want to track net time spent on your tasks. You can further aggregate on these lists of clock-in/clock-out times, e.g. calculate the total time per task from start to finish:
[Clock outs].Max() - [Clock ins].Min()
or calculate individual intervals:
Sequence(1, thisRow.[Clock outs].Count()).FormulaMap( thisRow.[Clock outs].Nth(CurrentValue) - thisRow.[Clock ins].Nth(CurrentValue) )
or calculate the sum of break times, but filter out breaks that are 3+ hours long, you name it