Challenge #106: How Long were the Lights On?

[RWvanLeeuwen]

Done! Checking for duplicate time is a fun thing to do, but I'm not aware what kind of detection sensor that would be to detect another person entering the room. Anyways, here's my take on this challenge:

Spoiler

[knhinson]

Learned how to generate rows! 

Spoiler

[justindavis]

Spoiler

[MikeHinz]

Took the very simple approach here:

Spoiler

[mcultrera]

Solved by two different methods. This one was harder than I thought it would be after just reading the description.

[mbogusz]

Spoiler

[FranckR]

Interesting challenge and not so easy - I lose a lot of time on "Date Time" conversions but now I know that date/time functions have to be used with "Date Time" data and don't work with "Date" or "Time" data.

[AntoineR1509]

Pretty much the same as many.

[Carlithian]

Slowly getting through all these datetime ones now that its finally sunk in