Challenge #106: How Long were the Lights On?

[StevenBetts]

I used waaaaay too many formulae but I got there nevertheless

[mickael_gest]

My solution :)

Spoiler

[terry10]

Spoiler

[SeanAdams]

Love this - a "Gaps and Islands" challenge!

(the class of problems that deals with finding contiguous islands of data, or gaps)

Spoiler

i took a simple brute-force approach:
- generate 1 row per minute within the range
- Find unique
- count them

Gonna have a look at other solutions now for other ideas

[mceleavey]

Ha. I was stumped by a schoolboy error. Got there in the end.

Spoiler

I began by using DateTimeParse([Enter],"%I:%M %p") to convert both the Enter and Exit fields to a valid time format. I then used the "Generate Rows" tool to incrementally create each minute between the entry and exit times, and then fed this into a "Summarize" tool to count the distinct records. My logic was flawless, I was convinced, but then why was I getting more entries than the solution??

The equals sign. Remember not to double count the minute on exit! 
[Minutes]< [Exit_Time]

Once I noticed my schoolboy error, all was well.

That was more difficult than it needed to be. I need sleep.

[STate]

This one took me three tries to find a good flow, what a great challenge!

[gauravk]

my solution

[Wouter]

My solution:

Spoiler

[LauraScavino]

Spoiler

this one was very challenging!

[JordyMicheal]

Generate Rows is a go!!!

I don't think @NicoleJohnson realizes what an Alteryx beast she is!!!

Congrats on Inspire and thanks for the tip on the tool