Kapoor_Nitin
New Member
Hi All,
I have a spreadsheet that needs to determine the first time a user logged in to the system and the last time the user logged out.
The login and logout report comes from another system from which I copy and paste the data to my spreadsheet. .
Basically, since the users use the system to login and logout, they will have multiple records of logging in and out on a daily basis. I need to find the very first login record and last logout record per user. One big challenge is that people do night shifts as well where the login date and logout date can be different. For e.g. employee A login at 10:30 pm on Oct 21st and logout at 7:30 am on Oct 22nd.
I have attached the sample file.
I have a spreadsheet that needs to determine the first time a user logged in to the system and the last time the user logged out.
The login and logout report comes from another system from which I copy and paste the data to my spreadsheet. .
Basically, since the users use the system to login and logout, they will have multiple records of logging in and out on a daily basis. I need to find the very first login record and last logout record per user. One big challenge is that people do night shifts as well where the login date and logout date can be different. For e.g. employee A login at 10:30 pm on Oct 21st and logout at 7:30 am on Oct 22nd.
I have attached the sample file.