corresponding value for specific cells

i have a sheet in where in i have the log in time aux codes and log out time

- is there any way or any formula that i can use to get the corresponding calue for log in and log out

for example -

02-02-2016 11:24 log in
02-02-2016 11:24 aux code
02-02-2016 11:24 aux code
02-02-2016 11:55 aux code
02-02-2016 21:00 log out


-i want a formula that if i need the corresponding value for log in and log out instead of using a filter .

Assuming the data starts in row 2 and is in columns A:C the following formula will work:
=IF(ISNUMBER(IF(C2="Log In",MATCH("log out",C2:$C$100,0),"")),INDEX(B2:$B$100,IF(C2="Log In",MATCH("log out",C2:$C$100,0),""),1),"")

Extend beyond Cell C100 and B100 if you have to.