Challenge #106: How Long were the Lights On?

[Rima1776]

Solution Attached

[iamme012397]

FUN TO LEARN NEW THINGS

[treepruner]

I did have to peek at the solution to get unstuck...

[Gomes]

See my proposed solution.

[AnaisComyn]

Done ! 

[DPRC]

Learned more about DTC tool and Multi Row Formula doing this challenge than I thought I would....delighted to have done so.

[kevin025]

Looks easy but actually very challenging without knowing the use of Generate Rows

[JoePC]

Solution Attached

[KilianL]

I didn't think of generating rows, but it seems like the most dynamic and efficient solution here.

I approached it with the Multi-Row Formula, but if there are bigger full overlaps in the data, the results will not be correct.

Spoiler

[carmenrapariz]

Spoiler