Challenge #203: Everyone loves a toll booth

[Kucsi]

The totals are not so good, but the method is usable (i think)

Spoiler

[seinchyiwoo]

My total time is a little off from the result but here's my workflow.

Spoiler

[dsmdavid]

Mostly match the new solution -- some differences in the total time (it seems the solution given calculates the minutes for each segment, instead of calculating the difference in seconds and converting to minutes after aggregation)

[echuong1]

This can definitely be streamlined, but gets the job done!

Spoiler

[Victor_Mendes]

Spoiler

My solution  

[estherb47]

OK, so to match the times in the solution.......

Spoiler

you need to calculate the time blocks that someone is on the road, so the difference between time from point 1 to 2, point 2 to 3, and so forth. The problem with doing this is you lose one minute along the way as many of us have discovered. This solution gets you a matching one though:

Here's what I think captures the actual time on the road more accurately.....

Spoiler

by simply calculating the difference between time 1 and time 6 in a formula tool first, then transposing to find the segments, matching with a join, and summarizing

[jv1]

Spoiler

[danespoors]

I actually quite enjoyed this one. I still avoid using regex like the plague but it works without it so I'm happy.

[RWvanLeeuwen]

My proposed solution:

Spoiler