Hi All - Hoping someone can help
I have a large amount of date formula's and I am trying to get the average journey step delay between 1 - 2, 2 - 3, 3 - 4 and so on.
I have the below to be used for the equation;
Timestamp and journey point (please see attached)
I have been playing around with IF formula, average if and min max, but i haven't managed a clear workout. What i have attached is on one example of a journey, but i have manage journeys included in my sheet, over 100. is anyone able to provide insight?