Dear All,
I have one txt where have data user punch In and Punch Out but problem is both in one columns and there is not seprate defination like this entry for out and this entry for in there is only two columsn one for Emp_ID and second for datetime.
How can read that and calculate the time of each employee date wise like how many hourse and minuts and there can be possible someone punched only once so i need to defined no out time punched and there can be possible mutliple in and out so i need to check date wise each employees timeing and want to calculate how many hours and minuts.
43814 2021-09-01 06:02:58 800000000 2021-09-01 07:14:15 20140426 2021-09-01 07:27:44 43814 2021-09-01 07:29:40 20140426 2021-09-01 07:45:08 20140426 2021-09-01 08:05:51 20159977 2021-09-01 08:23:18 20140215 2021-09-01 08:27:45 103585732 2021-09-01 08:29:55 20140163 2021-09-01 08:37:21 20140319 2021-09-01 08:50:27 2014034 2021-09-01 08:59:13 2014086 2021-09-01 09:02:45 20140321 2021-09-01 09:18:15