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

Challenge #68: Elapsed Classroom Times

Alteryx Partner

 

Spoiler
I've also come up with a one formula tool solution. I really like the colorful support the new formula tool offers.

wc68.PNG

 

 

Alteryx Certified Partner

Same solution as most :)

 

Spoiler
Weekly Challenge 68.png
Asteroid

File under "More than one way to skin a cat"

Spoiler
I fully expected my DateTimeFormat + DateTimeParse + PadLeft formulas to be the 'official' solution - and then I looked at the formulas used in the official answer. ;)


Asteroid

I have some confusion between DateTimeParse and DateTimeFormat,  but with some trial and error I did manage to get a solution.

 

 

Highlighted
Alteryx Certified Partner

Learning so much today! :)

Alteryx Certified Partner

Here's my solution.  I transposed both time fields into one column to save having to run the conversions twice, but then had to cross-tab twice at the end, so I'm not sure if it actually saved any steps.

 

UPDATE: Looking at everyone else's solutions there are MUCH easier ways to do this, but I guess that's why this is a learning exercise. :-)

 

Spoiler
challenge-68.PNG

 

Alteryx Certified Partner

Solution attached.

Spoiler
Capture.PNG
Alteryx Certified Partner
Spoiler
challenge68.PNG

Looks like I could have probably done it with fewer formula tools? Found this one a bit fiddly.
Meteor

This challenge may seem simple, but there are some tricky points, including where a class begins in the morning and ends in the afternoon, which requires the absolute value between two times.

 

My solutions rarely use as few tools as possible; I've found that the more tightly wound the code within a tool is the harder it is to transition the project to someone else who may or may not have the same expertise (be it more or less). I like trying to use the base tools to solve the problem, and fully admit that I don't have a complete grasp of every tool in every category, but I'm trying!

Spoiler
Challenge68.PNG