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?

Eilean_
8 - Asteroid

RT

mpennington
11 - Bolide

Attached.

 

Spoiler
My brain jumped to the generate rows tools right away, but getting the date minutes to format correctly was challenging. Fun challenge.

%I:%M %p%I:%M %p
DataHabanero
9 - Comet

Great challenge!

mdsalmankhan89
8 - Asteroid

here is my solution !! 

alba5972
6 - Meteoroid
Spoiler
Spoiler
Sashikumar
8 - Asteroid

My solution.

Spoiler
ch106.PNG
Steph_Maddrell
8 - Asteroid
Spoiler
Steph_Maddrell_0-1620212991030.png

 

KevinHarrison
8 - Asteroid
Spoiler
It took me awhile to figure out this expression for the time %I:mm %P but once I got that everything came into place. Again, I don't have the elegant 2 tool solution and I could have used a formula tool for the datetime tool but I like to keep to the tools instead of buried formulas to make it easier for a fellow developer to see what is happening. 

KevinHarrison_0-1621310413060.png

 

RamonaJ
8 - Asteroid

Attached my solution

ShashankRaj12
8 - Asteroid