Challenge #106: How Long were the Lights On?

[brandnewday]

Hi all,

This is my first challenge, I acknowledge solution is not the most efficient but tried to explain every step.

Spoiler

[KeithZ]

One of those challenges where you just know you're doing it inefficiently.

[danilang]

My solution

Spoiler

Dan

[TwylaXBlack]

Spoiler

SPOILER

I don't want to admit how long this took me. Here is my go at it.

[Ruud]

The multi-field formula is unironically one of my favorite tools, so I tend to find excuses to use it.

Spoiler

[MattKing]

Spoiler

[Vinutha]

Tricky one with the overlap

[Ozzy_Campos]

Took me forever to get the generate rows segment working, but learned some things about quickly parsing AM/PM times

[PrivateStorm]

My solution to challenge #106 is attached.