Challenge #106: How Long were the Lights On?

[brig]

Spoiler

Oooh, enjoyed this one. 🙂 Love a bit of multi row!

[DemandEngineer]

This one made me think a little.  A couple of scenarios to account for 12 AM and 12 PM... overlapping time frames... but there is a scenario that might need specifying in the question though no data did this it's good to know the boundaries so you know you don't need to build for it... I added logic to take care of times that start just before midnight and end after midnight (technically another day).  I would suggest considering adding to the question time periods will only span one day (ending at midnight).

[Samanthaj_hughes]

Another one bites the dust 🙂

[RNG]

.

[JP_SDAK]

Here's my solution

[SaâdEnnassiri]

Hello

My proposal plz

[mag161]

What I really want to know is how to use the tool that made this shorter for the first solution.

[CharlesZ]

Inspirational solution demonstrating the capability of the Generate Rows tool.

[Arturo90]

My solution! learned something new today

[ehughes]

My solution

Spoiler