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.
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

## Challenge #68: Elapsed Classroom Times

7 - Meteor

Easy one!

10 - Fireball

fg AA soln 68

Alteryx

Spoiler

8 - Asteroid

Attached Solution.

8 - Asteroid
Spoiler

8 - Asteroid

Interesting challenge.

My solution:

1. Formula Tool: PedLeft function to create consistency and comparability amongst the start/end times.

2. DateTime Tool: Convert string to date format following the DateTime Function documenation.

https://help.alteryx.com/20213/designer/datetime-functions

4. Formula Tool: IF statement to find if time exists for class and DateTimeDiff to compute elapsed time.

Spoiler

10 - Fireball

My Solution...

7 - Meteor
Spoiler

Alteryx

I probably could have done this in fewer steps but wanted to work this out from a logical sequence.

Matt

8 - Asteroid

Took a while and to many formulas to solve this one.

Spoiler