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

data_wrangler
6 - Meteoroid
Spoiler
data_wrangler_1-1649085215987.png


Took me a while to solve this with the exact formatting, but it was worth it ! 😁

 

Sujithappaiah
7 - Meteor

Use Multiple formula tools instead of a consolidated one like the solution provided

 

Spoiler
Challenge 68.PNG
Bharrison10
8 - Asteroid

Solution

Amy_smart
11 - Bolide

Here is my solution.

caitlynle11
8 - Asteroid

I use Find Replace to convert the time :) Feel like there would be shorter approaches!

caitlynle11_0-1650521156878.png

 

TonyAndriani
9 - Comet

Reposting under my new user ID.

bold3d
8 - Asteroid

Here is my solution.

jrobiso2
8 - Asteroid

The official solution is a very convoluted formula. Plus the output is not . . . appealing, nor likely easily understood by Freshman college kids.

So I've split out a lot of the logic into Formulas, and did a bit more "making it pretty so the typical Freshman English major can understand it".

 

P.S. Since when does a class run for NEGATIVE time?  There's a few other things that would never pass a common-sense check.

RobbieA
8 - Asteroid

Challenge 68, completed with the help of the infamous @DataNath 

 

RobbieA_0-1651769837437.png

 

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1652025621449.png

 

Don't use datetime's to string function often so it was a nice test