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

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.

Alteryx Certified Partner

Same solution as most :)

Spoiler
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. ;)

Highlighted
Asteroid

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

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

Alteryx Certified Partner

Solution attached.

Aurora
Spoiler
Alteryx Certified Partner
Spoiler

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