How to check multiple login or entry in excel

[Jonas230ph]

Hi Guys,

I'm a big fan of this site it's very helpful. though i came across with this concern or problem in excel wherein, I want to find out the latest log in time and the Last log out time of our employee the difficult part of it they have multiple log in and out on the system and should recognized 24 hour shift. I already tried the index and match formula in excel seems to be the result are not accurate or wrong can you help me guys regarding this concern. I'll attached the project or excel file im working on now, hope you can enlightenment me with this concern,

 

[tyger0951]

Still needing help? If so respond again here. Im working on sme codes in avaya at this time and if ur still needing help i can assisti my trying this out. I have no need t build what your looking for cause a javabased version exist at work n our intranet to get that info. Let me know if still seeking help as would need a bit more info.