Challenge #106: How Long were the Lights On?

[Tom_Pilgrem]

Long winded solution compared to others - but it makes sense to me! 

---

@JoeM

Spoiler

Was ok once I figured out the generate rows tool. Useful tool to know of - that's why I do the challenges! 

Generate rows to produce one row for each minute for each room and then group by room and count distinct individual minutes. 

There must be a better way to convert the time string into a date/time function. But I was confused by the one tool solutions people were doing. 

---

[justin_winter]

Pretty straight-forward. Could have done it with 2 tools, but it would have been really ugly in the multi-row tool! Instead cleaned up dates first then calculated.

Spoiler:

[kelly_gilbert]

Spoiler

It looks like the two popular solutions used either generate rows or multi-row...  I chose the multi-row option.

[dominiklz]

Spoiler

another one of those challenges where you really gotta sit back and think for a moment, had the idea with generate rows rightaway but then tried beating it to death with convoluted multi-row formulas, even though it could have been so easy...

[mascarenhas_lucas]

I'm not happy with my solution, I think it might have a better way to solve this problem!

Spoiler

[daniel_ferreira]

Follow my solution file attached...

[kennydso]

[ivoller]

I was making it more difficult than necessary. Then I saw the light!