Time calculations with data collected by a form
I am using a form to collect data that includes a unique ID for each user. The user will check in by completing the form with their ID and "Arriving". When the user is done, the user completes the form again and selects "Leaving". I now have two rows of data where I extract the time in and time out from the creation date/time such as
How can I evaluate the ID and Status to find the values to calculate the total time. In other words, where ID matches a 'leaving' and 'arriving for each 'date' then calculate the total time spent in the room (leaving time - arriving time).
Help Article Resources
Check out the Formula Handbook template!