View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135 via135 is offline
external usenet poster
 
Posts: 94
Default time_report_date-wise_employee-wise

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
01/03/2014 1525336 09:27
01/03/2014 1525336 09:41
01/03/2014 1525336 09:58
01/03/2014 1525336 10:06
01/03/2014 1525948 10:14
01/03/2014 1525948 10:14
01/03/2014 1525948 10:22
01/03/2014 1525948 10:47
03/03/2014 1525336 10:13
03/03/2014 1525336 10:53
03/03/2014 1525336 10:59
03/03/2014 1525336 11:04
03/03/2014 1525336 11:19
03/03/2014 1525336 11:36
03/03/2014 1525948 10:16
03/03/2014 1525948 10:17
03/03/2014 1525948 10:17
03/03/2014 1525948 10:18
03/03/2014 1525948 10:18
03/03/2014 1525948 10:37
04/03/2014 1525336 10:09
04/03/2014 1525336 10:13
04/03/2014 1525336 10:23
04/03/2014 1525336 10:43
04/03/2014 1525948 10:12
04/03/2014 1525948 10:13
04/03/2014 1525948 10:14
04/03/2014 1525948 10:14
04/03/2014 1525948 10:20

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
03-03-2014 1525336 10:13 11:36
03-03-2014 1525948 10:16 10:37
04-03-2014 1525336 10:09 10:43
04-03-2014 1525948 10:12 10:20

Help please.

Regards.

-via135