Challenge #106: How Long were the Lights On?

[MMehdi]

Amazing way of thinking, bravo

[kartheek31]

My first work in Weekly Challenge 

[ddiesel]

Being too stubborn to peek at the spoilers, I used 12 tools in my solution. I refuse to admit how many minutes it took me to solve this one. It was deceptively tricky!

I enjoyed checking out all the answers so far. This was a good one!

My solution:

[PhilipMannering]

Took me a little longer than expected. Would be good to have a TimeAdd() function, as well as the DateTimeAdd()

Spoiler

[kat]

I went waaaaaay too complicated!

Spoiler

[CHarrison]

Think I over complicated things slightly, but got a nice solution in the end :) 

[gnans19]

Never thought this would be so complicated. This crushed my ego. Always something new to learn and keeps life interesting.

[iain_sterland]

Mmm, took a while for me to convert the times-strings into Time-types - looking forward to learning an easier way :)

Spoiler

[ggruccio]

I kept thinking there must be an easier way - but I probably built it the hard way!  Very satisfying to get the result!!!