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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #68: Elapsed Classroom Times

Some of us are doing this challenge way late, just for practice. I decided to take the "formula tool" route rather than using the date/time conversion tools. I also wanted to include "AM" and "PM" in the standard time columns, as it drives me crazy to see just "6:00" (in the military this could easily be either morning or evening and the poor student might make a big mistake). I also wanted to flag those records where the begin time was apparently after the end time (leading to a negative elapsed time calculation). Unless begin time 1600 to end time 1000 (record 476) actually means an 18 hour class that starts one day and finishes the next...I haven't looked yet at the official solution to see if there was any commentary about that...

Um, what the heck is a "bayron", that is my apparent rank? Was this meant to be "baryon" by chance?

Alteryx Partner
Spoiler
Capture.PNG

Solution attached. 

Quasar

My solution:

Alteryx Certified Partner

Was able to do most of the calculations for this in 1 tool!

 

Spoiler
Challenge68.jpg
Asteroid

 

I guess not much to say about that. Pretty straight forward. Did a 2 tool solution with a few formulas to handle Nulls and TBA. I started by trying to convert to number. If unsuccessful replace by Null. It think that parsing the original field would make more sense. But that is just me.

 

Spoiler
challenge_68_start_file_MarMu.png 

 

Meteor
 
Alteryx Certified Partner

Just used the Formula tool for this one

Asteroid
Spoiler
68.png

Here is my solution. 

Asteroid

Hi @JoeM,

 

Here is my solution.

 

Thanks and Regards,

Samuel