Challenge #106: How Long were the Lights On?

[griffinwelsh]

My solution

[HyungchanRho]

Solution of #106

[Gugum]

My Weekly Challange #106 : How Long were the Lights On?

[cmoussa]

[SunkyuHan]

Here I am.

[DylanBell]

My solution:

[DylanBell]

My solution

[KLTerrell]

My (admittedly, a bit clunky) attempt (not as cool as the solutions using Generate Rows - I need to work on that tool!)

Spoiler

 

[blairmbailey]

Solution attached! Thank you!

[JBevan89]

My Solution attached.

I found this one quite interesting, as surely we should be able to just use Time instead of DateTime.  Perhaps Alteryx needs to look into this?

I really like the Generate Rows tool, because in certain situations it needs a row for each unit.  And then that data can be summarized.

But why does the format within the Generate Rows tool (or even if we used the formula tool or other tools) have to be DateTime.  It kind of spoils the tidiness of it.  And most importantly, it would be a lot straight forward if it could be a unit and format of just time