What type of solution are you looking for? VBA? or Excel functions? If you're wanting a brute-force method, I would: Insert a column and use it to combine the userid and date (=A2 & ":" & B2) copy it down, then copy, paste sepecial-> values to remove the formulas. Copy this column to a new sheet.
Then, sort the first sheet by the combo-column and the time in ASCENDING order. On the second sheet, use vlookup to look up the time (copy/pasteSpecialvalues) then, sort the first sheet by combo-column and time in DESCENDING order. use vlookup again to get the ending time. Now, if you're looking for something that says: user xxxx start: 0500 stop 0800 dur: 0300 start 0830 stop 1130 dur 0300 then we'll have to look at a VBA solution. Paul ________________________________ From: sachin or <sachin...@gmail.com> To: excel-macros@googlegroups.com Cc: shreyaskumar...@gmail.com Sent: Thu, June 24, 2010 11:48:14 AM Subject: $$Excel-Macros$$ Entry and exit report Hi All, Attached is the excel sheet. Please help me in getting the report done. I want the report to be designed in such a way that I have to get the data in Minimum Entry time and Max Exit Time for each employee on daily basis and also the “break time” taken. In simple words I want the Entry Time and Exit Time for each employee on daily basis. Please design the report in the simple formula if possible or Pivot is also fine. Please send the data at the earliest with the steps if possible. -- Regards, SACHIN OR -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
