Determine the last exit log

[krazyhype19]

Hi,

I have a conditional formatting in the "Access" tab that can determine the first entry log of each person. Now, I want to figure out how it can determine the last exit log based on their shift schedule. It should be applicable to those person in 8PM schedule. working hours is 9. If the working hours is < 9hrs then it should display the total number of hours undertime.

Please see my attached file.

Thank you!