Login - Logout report

**vamshi57** · 12-11-2009, 12:20 PM

Attached is the login-logout report for my team . Which gives me employee login time & logoff time . The dump has few entries which are repeated . For ex : In Cell D5 employee logged in , E5 has a logout time ( which is incorrect ) , while cell D6 has a login time ( which is incorrect ) , E6 has a logout time which is correct . So for 4th Dec I wanted to have D5 ( for login ) - E6 ( for logout ) . In the same way , I have many cells which has been repeated .

Hint - (1) Days shouldn't not be repeated . (2) Logout time shuld be greater than the login time for that day ( & rest should be eliminated for that day )

I'm not sure if I have explained it clearly or not. Do let me know if I can provide any other information .

**jrdnoland** · 12-11-2009, 12:30 PM

We would need to know what the employee is logging into and off of. Also, what is producing the dump? Where is the code?

**DonkeyOte** · 12-11-2009, 12:40 PM

Why not just push the data into a Pivot ?

Row Fields:
-- Name
-- Date

Data Fields:
-- Login Time set to MIN
-- Logout Time set to MAX
set number format of the above to h:mm:ss

This will give you per employee one record per day with their respective IN/OUT times
(above assumes shifts don't cross midnight)

**JBeaucaire** · 12-11-2009, 12:45 PM

This should take care of it for you:

Please Login or Register  to view this content.

===========
How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet

The macro is installed and ready to use. Press Alt-F8 and select LogInOutMerge from the macro list.

Try this on a copy of your data.

**vamshi57** · 12-11-2009, 01:19 PM

Awesome ... Macro is too good .. It exactly gave me the results I needed . Thanks much

**JBeaucaire** · 12-11-2009, 01:23 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

**vamshi57** · 12-11-2009, 01:52 PM

I previous sheet I have attached is modified by me to make my explanation easier . Can you modify the macro to adjust the below format . Infact I get the dump in the attached format .

Quick question - Is there any way this can be done by formulaes or through pivots ,,,, just in case . as it would be easier - irrespective of what format I have the data in . If not no issues , I'm still okay with macro .

**JBeaucaire** · 12-11-2009, 02:09 PM

This will work on the shown layout, and it will adjust the columns to display the times for you:

Please Login or Register  to view this content.

**mskumar507** · 04-18-2016, 11:44 PM

Can any help regarding
Excel sheet has 3 columns A has login and logout time and B has name of employee and C has date. Here i wanted to copy first login of the employee and last logout of the employee on the day to another sheet in the same excel.
Here employee can login and logout more then once. For example if employee login 3 times and 3 times logged out then we will have three records in the day from that we need to copy the first login and last logout time to another sheet.

I hope i explained good. Please provide me macro for this as i am beginner for macro in could not able to write.

**FDibbins** · 04-19-2016, 12:38 AM

mskumar507 welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.