Challenge #106: How Long were the Lights On?

[myastarling]

Here are two solutions - one that compares adjacent values, groups by those values and then sums based on those (good for a ginormous dataset) and one that creates all possible minutes when the light is left on and then counts the distinct values (good for smaller datasets).

[TomashevskiiVladimir]

 

[martinson]

👾

[Pilsner]

My solution:

Spoiler

 

[RebekaMazuchova]

:)

[Daniel_Homola]

Here!

[jaredcoffin]

Calculated the differences with the Formula tool then correct the duration in the Multi-Row tool with two outcomes.

1. First solution was to make a Lights On column with accumulation, correcting Duration.
2. Second solution was to set Duration column to 0 if Exit times were earlier than their successor, and correct Duration to start at previous Exit time if current Enter > prev Exit. 

[PuffinPanic]

Got there eventually, but it definitely looks like I could do with working more with the datetime functions.