On Sunday, 9 March 2014 23:35:52 UTC+5:30, via135 wrote:
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



Hi Claus,

I am getting value 0 in all the cells.!

-via135