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

AJauniskis
8 - Asteroid

My solution

 

Spoiler
workflow.JPG
ipeng
8 - Asteroid

My solution

nini
8 - Asteroid

My solution

DavidThorpe
Alteryx
Alteryx

My solution:

 

Spoiler
I completed this with a single formula tool, I've left out the data cleaning at the end, as it does the job!
RichoBsJ
11 - Bolide

Hi! Here my solution :)

EW
11 - Bolide

My solution:  

 

Spoiler
I wanted to make it way too complicated to avoid having separate formulas for begin/end times, but ended up just having one formula tool with  a bunch of formulas.

068EW.PNG
TharunReddy
8 - Asteroid

STEP 1: Use the multi-field formula tool to convert the Military time to standard time

STEP 2: Formula tool to get the number of minutes elapsed

 

Happy practice :)

KeithTroutt
8 - Asteroid

My solution

Spoiler
Challenge 68 Spoiler.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler
Would have been just one tool if I didn't include the Select or the Expect Equal to verify that I got the same results as the provided output.

Capture.PNG
Karam
8 - Asteroid

Solution attached.

 

Spoiler
challenge 68.PNG