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