Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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