Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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