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