community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #68: Elapsed Classroom Times

Asteroid

My solution

 

Spoiler
workflow.JPG
Asteroid

My solution

Asteroid

My solution

Alteryx
Alteryx

My solution:

 

Spoiler
I completed this with a single formula tool, I've left out the data cleaning at the end, as it does the job!
Highlighted
Asteroid

Hi! Here my solution :)

Asteroid

My solution:  

 

Spoiler
I wanted to make it way too complicated to avoid having separate formulas for begin/end times, but ended up just having one formula tool with  a bunch of formulas.

068EW.PNG
Asteroid

STEP 1: Use the multi-field formula tool to convert the Military time to standard time

STEP 2: Formula tool to get the number of minutes elapsed

 

Happy practice :)

Asteroid

My solution

Spoiler
Challenge 68 Spoiler.PNG
Quasar
Spoiler
Would have been just one tool if I didn't include the Select or the Expect Equal to verify that I got the same results as the provided output.

Capture.PNG
Alteryx Partner

Solution attached.

 

Spoiler
challenge 68.PNG