Challenge #106: How Long were the Lights On?

[olivia_paquot]

Nice one :-)

[cadyb]

This was a tricky one! I went the Multi-Row formula route at first and then a light turned on in my head (lol) and I used Generate Rows. I learned that DateTimeAdd requires a DateTime field and agree that a TimeAdd() function may be nice :)

[acrahen]

Spoiler

[payam2]

I'm glad the new Designer update has fixed the proxy issue. Now I can move on to other internet connected challenges I wasn't able to do.

[dsmdavid]

 Surprised that parsing AM/PM took extra effort (%p only for output?).

Spoiler

Still unable to upload files, so here's the link: https://dsmdaviz.com/wp-content/uploads/2018/12/solved%23106.yxmd

[catarina_pimpao]

Spoiler

[Steven_Pocoroba2]

Solution attached.

[ianwi]

Attached my workflow which includes a failed attempt in a container. I thought it may be useful to someone else to see the mistakes I make too...

Spoiler

[T_Willins]

Went down a rabbit hole at first trying to use multi-row formulas to eliminate overlapping end and start times and coming up with the differences between combined enter and exit times.  Got within one minute of the answer, but realized would take several multi row formulas to achieve the correct result.  Realized the need to find unique times and came up with a similar workflow to the others.

[RolandSchubert]

My solution