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?

Ioana_Radoveneanu
8 - Asteroid

done 🙂

 

Spoiler
106ioana.png
DanJ3
8 - Asteroid
Spoiler
Spoiler
106_sol_DanJ3.PNG
johnemery
11 - Bolide

I opted to use more tools in lieu of creating one very complicated formula in a single tool. As long as it gets the job done!

 

Spoiler
Datetimeadd doesn't always work 100% correctly with Time fields. It's very helpful to append a date to make it a Datetime.

Capture.PNG
tiffany_chen
8 - Asteroid

Really cool solution refer to other's. Interesting Learn!

Spoiler
Annotation 2020-01-17 000330.png
SarkaHubacek
8 - Asteroid
Spoiler
Screen Shot 2020-01-19 at 9.41.15 pm.png

On the first try I ended up with negative numbers, theeeen I got it!  XD  Four-tool solution attached

Spoiler
Angela_M_Burks_0-1579561882395.png
AndrewS
11 - Bolide

Down to 3. Kudos to those who managed in 2.

 

Spoiler
Capture106.PNG

 

 

JennyMartin
9 - Comet
Spoiler
AWC106.PNG

Nice little challenge

tiffanyshaw
8 - Asteroid
Spoiler
tiffanyshaw_0-1581530443556.png

 

kellygentry1
7 - Meteor