I will be grateful If someone can help me with this task:
I have the data from our "Attendance Machine". I need to calculate the "Total Time" considering that solution should be able to sort the data by employee and date. It should also be able to recognize if there are two time stamps are available. If only one is available, 0 hrs should be calculated. If there are more than 2 time stamps for the same date than first and last time stamps should be considered. There will be cases where "IN" stamp will be in before the midnight and "OUT" stamp will be in next calendar date. If all this can be done in a separate formatted sheet, will be excellent.
It appears to me that this quite a big task and I will be very thankful for the solutions. Sample data is as follows:
[TABLE="width: 394"]
<tbody>[TR]
[TD]No.[/TD]
[TD]User ID[/TD]
[TD]Department[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]Event[/TD]
[/TR]
[TR]
[TD="align: right"]1636[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]8:33:27[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1614[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]17:04:01[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1557[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]8:26:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1475[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]8:24:26[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1453[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]16:56:15[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1300[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]8:29:59[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1279[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]16:56:40[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1133[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]8:29:50[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1111[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]16:57:38[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1040[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]8:36:10[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]996[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]18:29:13[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]953[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]8:35:18[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]932[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]17:00:36[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]861[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]8:53:35[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]839[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]17:21:51[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]776[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]8:34:38[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]751[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]16:47:39[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]631[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]13:36:28[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]613[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]16:46:22[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]544[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]8:12:44[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]518[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]16:56:47[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]449[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]8:23:25[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]434[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]14:38:50[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]357[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]8:57:19[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]341[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]16:29:25[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]273[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]8:05:13[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]89[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]8:31:56[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]16:53:30[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]25/3/2019[/TD]
[TD="align: right"]8:14:53[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1664[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]22:14:43[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1689[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]13:47:03[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1663[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]22:14:52[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1627[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]13:54:03[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1590[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]21:56:07[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1507[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]21:55:23[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1545[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]13:55:54[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1463[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]13:55:12[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1422[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]22:02:22[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1369[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]6/3/2019[/TD]
[TD="align: right"]15:01:54[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1335[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]6/3/2019[/TD]
[TD="align: right"]21:59:16[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1289[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]13:58:54[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1249[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]22:03:21[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1199[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]9/3/2019[/TD]
[TD="align: right"]13:26:24[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1174[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]9/3/2019[/TD]
[TD="align: right"]22:01:35[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1122[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]13:45:37[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1077[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]22:00:02[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1032[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]13:09:33[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]989[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]22:02:30[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]944[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]13:33:48[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]897[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]22:06:29[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]857[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]13:07:09[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]814[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]22:00:25[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]768[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]13:43:56[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]720[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]22:12:05[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]703[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]16/3/2019[/TD]
[TD="align: right"]6:10:47[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]693[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]16/3/2019[/TD]
[TD="align: right"]13:54:37[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]658[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]6:16:53[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]529[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]14:03:03[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]475[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]5:57:42[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]435[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]14:11:43[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]376[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]7:12:38[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]350[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]13:57:58[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]282[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]7:52:40[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]260[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]14:01:28[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]182[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]23/3/2019[/TD]
[TD="align: right"]6:03:44[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]162[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]23/3/2019[/TD]
[TD="align: right"]14:02:15[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]104[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]7:53:13[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]77[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]14:10:04[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]25/3/2019[/TD]
[TD="align: right"]6:59:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1647[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]7:15:21[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1618[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]16:22:47[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1567[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]7:27:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1537[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]16:28:08[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1474[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]8:24:50[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1455[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]16:27:54[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1399[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]6/3/2019[/TD]
[TD="align: right"]7:15:35[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1311[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]7:21:03[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1280[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]16:29:26[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1146[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]7:22:41[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1113[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]16:22:00[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1052[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]7:21:15[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1021[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]16:29:42[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]866[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]8:08:38[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]620[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]16:30:59[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]642[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]8:14:20[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]619[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]16:31:05[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]555[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]7:12:30[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]522[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]16:26:39[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]461[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]7:09:22[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]427[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]16:26:32[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]355[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]11:37:47[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]342[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]16:24:49[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]283[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]7:17:02[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]254[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]16:26:51[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]25/3/2019[/TD]
[TD="align: right"]7:14:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1668[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]21:57:56[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1685[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]14:10:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1666[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]21:58:07[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1619[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]16:09:02[/TD]
[TD]IN[/TD]
[/TR]
</tbody>[/TABLE]
I have the data from our "Attendance Machine". I need to calculate the "Total Time" considering that solution should be able to sort the data by employee and date. It should also be able to recognize if there are two time stamps are available. If only one is available, 0 hrs should be calculated. If there are more than 2 time stamps for the same date than first and last time stamps should be considered. There will be cases where "IN" stamp will be in before the midnight and "OUT" stamp will be in next calendar date. If all this can be done in a separate formatted sheet, will be excellent.
It appears to me that this quite a big task and I will be very thankful for the solutions. Sample data is as follows:
[TABLE="width: 394"]
<tbody>[TR]
[TD]No.[/TD]
[TD]User ID[/TD]
[TD]Department[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]Event[/TD]
[/TR]
[TR]
[TD="align: right"]1636[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]8:33:27[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1614[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]17:04:01[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1557[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]8:26:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1475[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]8:24:26[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1453[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]16:56:15[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1300[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]8:29:59[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1279[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]16:56:40[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1133[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]8:29:50[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1111[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]16:57:38[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1040[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]8:36:10[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]996[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]18:29:13[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]953[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]8:35:18[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]932[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]17:00:36[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]861[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]8:53:35[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]839[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]17:21:51[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]776[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]8:34:38[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]751[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]16:47:39[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]631[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]13:36:28[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]613[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]16:46:22[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]544[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]8:12:44[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]518[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]16:56:47[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]449[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]8:23:25[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]434[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]14:38:50[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]357[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]8:57:19[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]341[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]16:29:25[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]273[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]8:05:13[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]89[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]8:31:56[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]16:53:30[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]1000[/TD]
[TD]General[/TD]
[TD="align: right"]25/3/2019[/TD]
[TD="align: right"]8:14:53[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1664[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]22:14:43[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1689[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]13:47:03[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1663[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]22:14:52[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1627[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]13:54:03[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1590[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]21:56:07[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1507[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]21:55:23[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1545[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]13:55:54[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1463[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]13:55:12[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1422[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]22:02:22[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1369[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]6/3/2019[/TD]
[TD="align: right"]15:01:54[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1335[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]6/3/2019[/TD]
[TD="align: right"]21:59:16[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1289[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]13:58:54[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1249[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]22:03:21[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1199[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]9/3/2019[/TD]
[TD="align: right"]13:26:24[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1174[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]9/3/2019[/TD]
[TD="align: right"]22:01:35[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1122[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]13:45:37[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1077[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]22:00:02[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1032[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]13:09:33[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]989[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]22:02:30[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]944[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]13:33:48[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]897[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]12/3/2019[/TD]
[TD="align: right"]22:06:29[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]857[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]13:07:09[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]814[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]22:00:25[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]768[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]13:43:56[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]720[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]14/3/2019[/TD]
[TD="align: right"]22:12:05[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]703[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]16/3/2019[/TD]
[TD="align: right"]6:10:47[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]693[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]16/3/2019[/TD]
[TD="align: right"]13:54:37[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]658[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]6:16:53[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]529[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]14:03:03[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]475[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]5:57:42[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]435[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]14:11:43[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]376[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]7:12:38[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]350[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]13:57:58[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]282[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]7:52:40[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]260[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]14:01:28[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]182[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]23/3/2019[/TD]
[TD="align: right"]6:03:44[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]162[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]23/3/2019[/TD]
[TD="align: right"]14:02:15[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]104[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]7:53:13[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]77[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]24/3/2019[/TD]
[TD="align: right"]14:10:04[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD="align: right"]1012[/TD]
[TD]General[/TD]
[TD="align: right"]25/3/2019[/TD]
[TD="align: right"]6:59:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1647[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]7:15:21[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1618[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]16:22:47[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1567[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]7:27:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1537[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]4/3/2019[/TD]
[TD="align: right"]16:28:08[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1474[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]8:24:50[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1455[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]5/3/2019[/TD]
[TD="align: right"]16:27:54[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1399[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]6/3/2019[/TD]
[TD="align: right"]7:15:35[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1311[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]7:21:03[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1280[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]7/3/2019[/TD]
[TD="align: right"]16:29:26[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1146[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]7:22:41[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1113[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]10/3/2019[/TD]
[TD="align: right"]16:22:00[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1052[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]7:21:15[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1021[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]11/3/2019[/TD]
[TD="align: right"]16:29:42[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]866[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]13/3/2019[/TD]
[TD="align: right"]8:08:38[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]620[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]16:30:59[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]642[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]8:14:20[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]619[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]17/3/2019[/TD]
[TD="align: right"]16:31:05[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]555[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]7:12:30[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]522[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]18/3/2019[/TD]
[TD="align: right"]16:26:39[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]461[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]7:09:22[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]427[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]19/3/2019[/TD]
[TD="align: right"]16:26:32[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]355[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]11:37:47[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]342[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]20/3/2019[/TD]
[TD="align: right"]16:24:49[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]283[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]7:17:02[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]254[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]21/3/2019[/TD]
[TD="align: right"]16:26:51[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]1015[/TD]
[TD]General[/TD]
[TD="align: right"]25/3/2019[/TD]
[TD="align: right"]7:14:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1668[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]21:57:56[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1685[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]14:10:51[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD="align: right"]1666[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]21:58:07[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD="align: right"]1619[/TD]
[TD="align: right"]1023[/TD]
[TD]General[/TD]
[TD="align: right"]3/3/2019[/TD]
[TD="align: right"]16:09:02[/TD]
[TD]IN[/TD]
[/TR]
</tbody>[/TABLE]
