ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #68: Elapsed Classroom Times

PrzemekNabozny
Meteoro

Hi,

Solution attached. Could be solved by one complex formula, but multiple controls make it easy to understand and change, if needed.

Spoiler
flow.png

zraposoaandm
Asteroide
Spoiler
Capture68.PNG
lwolfie
Bólido

Not sure how I missed submitting this one.

rapetter
Asteroide

Done

Megha6791
Meteoroide

Another way of doing it. I have kept all the stages of work output. We can use select tool in the end to remove the columns not required anymore.

Kept it for the purpose of step by step clarity

brunoponne
Meteoro

Seemed an easy task, but I took some time to learn all formatting symbols for time in Alteryx. Good learning!

 

Spoiler
Challenge 68.png
classyTeddy
Asteroide

Good use of DateTime functions. Should include an error-handling step for those problematic data. But just leave as it is to follow the Target Output.

heatherw
Meteoroide
Spoiler
Spoiler-I made this way too complicatedScreenshot 2024-08-11 130814.png
delosreyesjeric
Meteoro

Challenge #68 Completed!

Supriya2203
Asteroide

My solution