time_report_date-wise_employee-wise
Hi,
Am Sun, 9 Mar 2014 11:05:52 -0700 (PDT) schrieb via135:
I am having date-wise, employee-wise login logoff data in Col A to C as under
DATE EMP_NO TIME
01/03/2014 1525336 09:04
01/03/2014 1525336 09:04
What I want is date-wise, employee-wise login (starting time) logoff (ending time) report for each of the employees as example given for the above list as under;
DATE EMP_NO LOG_IN LOG_OUT
01-03-2014 1525336 09:04 10:06
01-03-2014 1525948 10:14 10:47
your data in Sheet1. Then in Sheet2 C2:
=MIN(IF(Sheet1!$A$2:$A$100&Sheet1!$B$2:$B$100=A2&B 2,Sheet1!$C$2:$C$100))
and in D2:
=MAX(IF(Sheet1!$A$2:$A$100&Sheet1!$B$2:$B$100=A2&B 2,Sheet1!$C$2:$C$100))
Enter both array formulas with CTRL+Shift+Enter and copy down
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|