# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

## Challenge #203: Everyone loves a toll booth

8 - Asteroid

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

Spoiler

Highlighted
Alteryx

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

Spoiler

Highlighted
8 - Asteroid

Highlighted
Alteryx Partner

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)

Highlighted
Alteryx

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

Spoiler

Highlighted
Alteryx Certified Partner
Spoiler

My solution

Highlighted
14 - Magnetar

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

Highlighted
Alteryx Partner
Spoiler

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner

My proposed solution:

Spoiler