Gallery
Share
Explore

icon picker
Template Periods and Breaks

grouping based only on start & end values
Christiaan Huizer

→ This template supports the blog you find below: ⤵️

⁠
Template Periods and Breaks
grouping based only on start & end values
coda.io
⁠
⁠

⁠

DB Tasks
Name
rowIndex
timeStart
timeEnd
step01-Unique Slots
step02-startPoints
step03-startTasks
step04-endNumbers
step04-endTasks
step05-delta
step06-wrapped up
1
Task 1
1
1/25/2023, 8:00 AM
1/25/2023, 9:00 AM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
2
Task 2
2
1/25/2023, 8:30 AM
1/25/2023, 9:00 AM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
3
Task 3
3
1/25/2023, 9:00 AM
1/25/2023, 9:30 AM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
4
Task 4
4
1/25/2023, 9:00 AM
1/25/2023, 11:00 AM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
5
Task 5
5
1/25/2023, 10:00 AM
1/25/2023, 11:00 AM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
6
Task 6
6
1/25/2023, 10:30 AM
1/25/2023, 11:00 AM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
7
Task 7
7
1/25/2023, 1:00 PM
1/25/2023, 3:30 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
8
Task 8
8
1/25/2023, 3:00 PM
1/25/2023, 3:30 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
9
Task 9
9
1/25/2023, 3:00 PM
1/25/2023, 4:30 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
10
Task 10
10
1/25/2023, 6:00 PM
1/25/2023, 6:30 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
11
Task 11
11
1/25/2023, 6:30 PM
1/25/2023, 10:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
12
Task 12
12
1/25/2023, 6:30 PM
1/25/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
13
Task 13
13
1/27/2023, 8:00 PM
1/27/2023, 9:30 PM
1/25/2023, 8:00 AM1/25/2023, 10:00 AM1/25/2023, 10:30 AM1/25/2023, 1:00 PM1/25/2023, 3:00 PM1/25/2023, 6:00 PM1/25/2023, 6:30 PM1/27/2023, 8:00 PM
1/25/2023, 8:00 AM1/25/2023, 10:30 AM1/25/2023, 3:00 PM1/25/2023, 6:30 PM
Task 1
Task 6
Task 8
Task 9
Task 11
Task 12
05781011
Task 5
Task 7
Task 8
Task 10
Task 11
3 hrs5 hrs30 mins3 hrs 30 mins3 hrs 30 mins
1/25/2023, 8:00 AM → 1/25/2023, 11:00 AM: 3 hrs
1/25/2023, 10:30 AM → 1/25/2023, 3:30 PM: 5 hrs
1/25/2023, 3:00 PM → 1/25/2023, 3:30 PM: 30 mins
1/25/2023, 3:00 PM → 1/25/2023, 6:30 PM: 3 hrs 30 mins
1/25/2023, 6:30 PM → 1/25/2023, 10:00 PM: 3 hrs 30 mins
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.