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 #87: Losing Daylight

ArdianDaka
8 - Asteroid

My Solution

Spoiler
ArdianDaka_0-1648850640568.png

 

DennisK
8 - Asteroid

Attached solution :)

SamSearch
7 - Meteor
Spoiler
SamSearch_0-1649084853675.png

 

josh_dykstra
8 - Asteroid

done!

RobPearce
8 - Asteroid

Yay!  I actually wrote a (simple) multi-row formula, instead of just stealing it! - Achievement unlocked.

Bharrison10
8 - Asteroid

Solution

Sujithappaiah
7 - Meteor

Ended up being fairly lenghty, gotta see other solutions and get some ideas

 

Spoiler
Challenge 87 solved.PNG
Sujithappaiah
7 - Meteor

 

Could you help explain how the first formula works in your solution 

Spoiler
DateTimeParse(left([Sunrise],2+FindString([Sunrise], "am")),"%I:%M %P")
TonyAndriani
9 - Comet

Reposting under my new user ID.

Amy_smart
11 - Bolide

I have attached my solution.