Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
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.