cancel
Showing results 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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #68: Elapsed Classroom Times

Meteoroid

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

Meteoroid

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

Alteryx Partner
Spoiler

Solution attached.

Quasar

My solution:

Alteryx Certified Partner

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

Spoiler
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

Meteor

Alteryx Certified Partner

Just used the Formula tool for this one

Asteroid
Spoiler

Here is my solution.

Asteroid

Hi @JoeM,

Here is my solution.

Thanks and Regards,

Samuel