can you explain how you intended to rejoin the data? I saw only one index column and I couldn't figure it out (which is why I re-tried the original solution).

I thought it's pretty clear it's a power pivot solution. Therefore, you have to open power pivot window to see the Exit Time column added to the Entry table.

That Exit Time formula simply reads the exit time from the Exits table.

Ah, I didn't have PP add-in turned on. Thanks for your help, again. Your patience and support have been deeply appreciated.