Multiple min and max
I have a data set that shows when customer visit different stores. I am trying to find time between when they visit one store and when they go to the next. I have a field for arrival and departure at each location. It is possible and even likely that guest will visit multiple sites in a day and even revisit a site. It is the revisit that is causing me issue. My first attempt was just to take the min and max of their timestamps for each location and compare those but has errors like in this example: