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?

nravik
11 - Bolide
Spoiler
Spoiler
DateTime was easy to work with!! 106.PNG

Sol Attached!!

 

Thanks for the challenge.

ReconBen
8 - Asteroid
Spoiler
ReconBen_106.JPG

wincenzo
7 - Meteor
Spoiler
wincenzo_0-1591872217018.png

 

shadakht
6 - Meteoroid

Here is my take to this solution. 

Oren_Soloman
8 - Asteroid

This one took me a while.  Got the answer though.

sumanthskumar
8 - Asteroid

Number 25
Generate row tool was my first thought but then I went ahead with the multi-row formula tool and ended up with a complex workflow. My facepalm moment came when I saw the other answers.

Spoiler
sumanthskumar_0-1592372817977.png

 

Tberney
8 - Asteroid

Took a while to get the overlaps right

Tberney_0-1592455618577.png

 

kmuralid57
7 - Meteor

Combined my two favorite solutions.

ChloeL-H
7 - Meteor

Great for honing your Multi-Row Formula Tool skills. Here is my solution:

Spoiler
Challenge_106_Solution.JPG
dombaikamilla
8 - Asteroid
Spoiler
106.PNG