Skip to content
DB Brussels - Paris
Applying a filter logic to calculate driving time
thisTable.Filter(
periods.Contains(thisRow.periods) and
occupation.Contains([Driving ]) and
stopTypes.Contains([Border crossing]).Not()).WithName(base,
If(
base.Count() = 1,
base.countDown,
base.delta)).First()
Name
stopTypes
occupation
timeSlots
periods
perPeriod
Action 1 Dep → Dépot Bus Partner
Garage
Driving
06:30
Driving period 1
15 mins
Action 2 Arr → Brussel North
Station
Break 1
06:45
Driver's break
Action 3 Dep → Brussel North
Station
Driving
07:00
Driving period 2
4 hrs 15 mins
Action 4 Arr → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
08:30
Driving period 2
4 hrs 15 mins
Action 5 Dep → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
08:30
Driving period 2
4 hrs 15 mins
Action 6 Arr → Paris (Bercy Seine)
Station
Break 2
11:15
Driver's break
Action 7 Dep → Paris (Bercy Seine)
Station
Driving
12:30
Driving period 3
4 hrs
Action 8 Arr → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
15:15
Driving period 3
4 hrs
Action 9 Dep → Border Crossing Hensies (B) / Crespin (F)
Border crossing
Driving
15:15
Driving period 3
4 hrs
Action 10 Arr → Brussel North
Station
Break 3
16:30
Driver's break
Action 11 Dep → Brussel North
Station
Driving
16:45
Driving period 4
15 mins
Action 12 Arr → Dépot Bus Partner
Garage
Driving
17:00
Driving period 4
15 mins
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.