Challenge #203: Everyone loves a toll booth

[pasccout]

I was really wondering how you came up with the total time on the road before I started reading the thread... same issue as others... prices match but not total time on the road.

[Amin]

Couldn't match the times too! Here's my attempt nevertheless!

Spoiler

Solution
 

[aanandkumar]

 Same as the others, my time values are different. I also realized that I made the solution more complicated than it needed to be. 

[AYXAcademy]

Start file updated on 2/19/20 to reflect corrected solution. 

[patrick_digan]

Spoiler

[huynv96]

A good challenge! My solution:

Spoiler

[reply_mueller]

Hey @AYXAcademy ,

thanks for the nice challenge.

You will find my solution attached below, the workflow is straight forward, using a (two) multi-row-formula to detect the previous booth and it's time. Then join the tolls and sum up for the solution.

Spoiler

Best,

Johannes

[ArtApa]

Here is my solution. In some cases minutes do not match to the "Output", but this is due to the difference in rounding techniques. I believe mine is more correct.

Spoiler

[BenMoss]

Solution as with others time is out by a minute. @patrick_digan 's solution seems to have the minutes the same, so perhaps one too look at if you are interested in understanding how Alteryx got their numbers 😄