Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #68: Elapsed Classroom Times

MinaGO
7 - Meteor
Spoiler
Screenshot (368).png

All in one tool! Spotted some problems in the original data so minorly cleaned before processing.

JustinMatthews
6 - Meteoroid
Spoiler
wk 68.JPG

After learning a few of the time specifiers this became pretty simple.

Natasha
9 - Comet

Used 3 formulas to get the answer, and then used two more to convert the answer to string as per output. I tried to wrap the last two formulas around my time calculations, but it didn't work in the same column for some reason. 

 

Spoiler
Screen Shot 2017-05-04 at 20.16.12.png
rohanonline
10 - Fireball

Here is my solution

JoeM
Alteryx Alumni (Retired)

Solution posted!! I hit the formula tool hard this week ;)

Natasha
9 - Comet

JoeM, thanks for another interesting solution! I learned something new again.

 

Realised that I didn't convert 24h to 12h before, so here is my updated solution.

 

estherb47
15 - Aurora
15 - Aurora

Here's my solution. Two approaches. One which is step by step, and one which does everything with long formulae in a formula tool

Spoiler
Spoilerimage.png
estherb47
15 - Aurora
15 - Aurora

Here's my solution. Two approaches. One which is step by step, and one which does everything with long formulae in a formula tool

Spoiler
Spoilerimage.png
sagarb
8 - Asteroid
 
Garrett
11 - Bolide

Wow that was unpleasant. Whatever happened to Alteryx requiring "no coding"?