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.