Range A2:C10 contains the login and logout times of various ID’s.
Each ID could log in and out a number of times a day.
How could we find the first time a specific ID logged in and the last time that same ID logged out?
For each of the ID’s in range A2:A10, enter two Array Formulas.
To find the first login time (Column B) enter the following formula:
To find the last logout time (Column C) enter the following formula:
ID______Login Time______Logout Time
ID______First Login Time______Last Logout Time
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.