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

CKP
10 - Fireball

My solution

 

Spoiler
challenge_68_mysolution.jpg
AnaisComyn
9 - Comet

Done !

treepruner
9 - Comet

I think I did this in about 2x as many steps as I should have...

KirstyHarvey
8 - Asteroid

Oooh - good one!

jarrod
ACE Emeritus
ACE Emeritus

 

I use this link way too often. I should probably print out a sheet to keep at my desk:
https://help.alteryx.com/2020.2/Reference/Functions.htm

Spoiler
jarrod_0-1594921868081.png

 

LittleE
8 - Asteroid

Hmm, I see now that I definitely could have done this easier by using the "custom" part of the date-time tool.  

Also note that I followed the written instructions, which call for outputs without the leading zeros (e.g. 8:30) as opposed to the output provided which included them (e.g. 08:30).

Spoiler
LittleE_0-1594964469083.png

 

Samanthaj_hughes
ACE Emeritus
ACE Emeritus

someone is having fun liking all these challenges 🙂

#Alteryxrocks
iamme012397
8 - Asteroid

hmm weird there were negative values

KevinHarrison
8 - Asteroid
Spoiler
KevinHarrison_0-1595957928878.png

 

troyeb4
8 - Asteroid

I could probably compress this significantly. Maybe for round 2.

Spoiler

troyeb4_0-1595968185521.png