First Time In and Last Time Out with Excel <p>I have a data below where I want to get the unique ID number and only get the first time in and last time out. The data looks something like this:</p> <p><a href="https://i.stack.imgur.com/32dJc.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/32dJc.jpg" alt="enter image description here"></a></p> <p>The result should be something like this:</p> <p><a href="https://i.stack.imgur.com/alCPu.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/alCPu.jpg" alt="enter image description here"></a></p>