Feroz Khan

Feroz Khan

  • 1.8k
  • 208
  • 59.1k

How can i get total hours and miniuts form txt files

Sep 5 2021 8:45 PM

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  

 

 


Answers (7)