Calculate the time spent in a room on G-sheet

I am trying to make a calculation on how to automatically see how long Paul, Jack and John spent in the room as shown on the enclosed pic. I cannot figure out if I should have an IF formula added with a VLOOK, but I am not sure and need your expertise. Please helpenter image description here