This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
This took longer than I wanted. I was able to to use DateTimeParse to parse the time, but couldn't create 24H time properly using DateTimeAdd without having a date as part of the field. I had to add today to the string before I could use it and then it was easy afterwards.
Converted the times into actual time fields, accounting for the AM/PM. Started down the path of using a MultiRow Formula tool, followed by a DateTimeDiff to calculate the number of minutes. This wound up being a problem because some of the enter times, when updated to be after the previous exit times, were after the exit time. Didn't want to deal with those problems.
Soon realized that I could just generate the minutes in between the two times, and then count the unique ones per room.