How to get the working hours\day

Steel Contributor

Hi guys,

We are using fingerprint device to record staff attending and leaving time. when we extract the monthly report from the device, we need to manipulate this report to serve our needs. The extracted reports contain four columns (Emp_ID,Emp_name, Date, time),

 

The device saves a record every time the employee put his/her fingerprint(either for time in or time out), so for every working day the employee must have two records ( we have a problem, some staff have just one record (see 3)  we do not know if it is for time in or out, some have double records for time in(see 12,13), some seems like the staff record the time out then he stayed more time then he record another time out (see 17,18,19)

 

* staff come and leave in different times


I need to calculate the working hours per day for every employee with taking the consideration the points mentioned above.

 

 Emp_IDEmp_NameDateTimeworking hours/Day
11Abdullah 02/02/201912:00 
21Abdullah 02/02/201918:06 
32Khaled02/02/201911:09 
43Ahmed02/02/201909:58 
53Ahmed02/02/201914:52 
64Akram 02/02/201912:29 
74Akram 02/02/201918:44 
85Saeed02/02/201908:07 
95Saeed02/02/201913:33 
106Mona02/02/201910:55 
116Mona02/02/201918:36 
127Hashem02/02/201911:08 
137Hashem02/02/201911:08 
147Hashem02/02/201919:06 
158Rana02/02/201909:41 
168Rana02/02/201913:17 
1710Ebrahim02/02/201909:27 
1810Ebrahim02/02/201914:24 
1910Ebrahim02/02/201914:36 
201Abdullah 03/02/201911:44 
211Abdullah 03/02/201918:35 
223Ahmed03/02/201909:53 
233Ahmed03/02/201914:56 
244Akram 03/02/201912:18 
254Akram 03/02/201918:43 
265Saeed03/02/201908:00 
275Saeed03/02/201913:11 
286Mona03/02/201913:32 
296Mona03/02/201918:35 
307Hashem03/02/201914:54 
318Rana03/02/201908:15 
328Rana03/02/201913:27 
3310Ebrahim03/02/201908:26 
3410Ebrahim03/02/201914:29 
0 Replies