I try to slice a list, using
listcombine() and it fails
I use this formula and this works fine if I create a list manually. Once a part of the list is the outcome of a filter, it fails.
It keeps me already busy for a while and I looked into the difference between l
listcombine(), but this did not help me.
the background is that I am trying to get the values in between breaks. so if a break ends at 6pm and driving ends at 9pm, it is 3 hours driving. That calculation is not the issue once I can slice as intended, but slicing the outcome of a filter is not so evident it appears.
thanks a lot!, Christiaan