Challenge #106: How Long were the Lights On?

[MarosS]

Not the shortest solution, but it works.

[martensite]

My solution! not very familized with the generate rows tool

[MichaelStaig]

Spoiler

[wwatson]

My solution

[klyuka]

Very useful ideas in this challenge: time converting and multy-row formulas.

[Rahma]

Fun use of multi row formula! solution attached. 

[Etienne]

Good challenge with dates. Attached my solution

[Inactive User]

Spoiler

Used formula tool to add seconds to the time and then used Date Time tool (%X custom format) to convert 12hr time to 24hr. Sorted time according to room, entry time and exit time. Used multi-row formula to write logic for calculating time. Summarized data according to room.

[Jonathan-Sherman]

Challenge 106 is done!

Spoiler