Guest User

Untitled

a guest
Dec 19th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. 2018-01-30 10:21:41
  2. 2018-01-17 12:22:50
  3. 2018-06-27 23:09:20
  4. INVALID
  5. INVALID
  6. ... for 800 Rows
  7.  
  8. 2018-01-30 10:23:54
  9. 2018-01-17 13:23:45
  10. 2018-06-28 06:10:56
  11. INVALID
  12. INVALID
  13. ... for 800 rows
  14.  
  15. 00:02:13
  16. 01:00:55
  17. 07:01:36
  18. INVALID //Where any instance of invalid in either file remain in the new file.
  19. INVALID
  20.  
  21. string1="10:21:41"
  22. string2="10:23:54"
  23. StartDate=$(date -u -d "$string1" +"%s")
  24. FinalDate=$(date -u -d "$string2" +"%s")
  25. date -u -d "0 $FinalDate sec - $StartDate sec" +"%H:%M:%S"
  26.  
  27. > 00:02:13
Add Comment
Please, Sign In to add comment