How can I calculate which column contains the last time entry for multiple rows?

[Indominus]

Hi, so I have a file very similar to this one. It is for work. Used to track clock in/out times from employees. I am trying to create a code to identify which employees are on the clock and which ones are not. I was doing a bunch of IF formulas nested but then I realized there could be more columns with clock punches due to duplicate/error punches. Essentially in simple terms I am requesting if there is any way to find out if the employee’s last punch was an In or an Out. That would be what I am looking for. Column E will always start with IN and always alternates. I am at lost with this. Thank you in advance! Here is a screenshot of a sample file

 

[Fluff]

How about

=LOOKUP(2,1/(E2:Z2<>""),$E$1:$Z$1)

 

[Indominus]

How about

=LOOKUP(2,1/(E2:Z2<>""),$E$1:$Z$1)

Wow thank you so much Fluff it works perfectly!!! How does this work exactly? I am trying to really up my knowledge and I have never heard of this function

 

[Fluff]

You're welcome & thanks for the feedback.
For how it works, have a look here Excel formula: Get value of last non-empty cell | Exceljet