Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #106: How Long were the Lights On?

jasperlch
12 - Quasar
 
brandnewday
7 - Meteor

Hi all,

 

This is my first challenge, I acknowledge solution is not the most efficient but tried to explain every step.

 

Spoiler

Challenge 106.PNG
KeithZ
8 - Asteroid

One of those challenges where you just know you're doing it inefficiently.

 

danilang
19 - Altair
19 - Altair

My solution

Spoiler
Solution 106.png

Dan

TwylaXBlack
8 - Asteroid
Spoiler
SPOILER

I don't want to admit how long this took me. Here is my go at it.

 

Ruud
10 - Fireball

 

The multi-field formula is unironically one of my favorite tools, so I tend to find excuses to use it.

 

Spoiler
Capture.PNG

 

MattKing
8 - Asteroid
Spoiler
image.png
Vinutha
8 - Asteroid

Tricky one with the overlap

Ozzy_Campos
8 - Asteroid

Took me forever to get the generate rows segment working, but learned some things about quickly parsing AM/PM times

PrivateStorm
8 - Asteroid

My solution to challenge #106 is attached.