Guest User

Untitled

a guest
Oct 18th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. CR_Date <- data.frame(
  2. pos1="2014-07-01 00:00:00",
  3. pos2=c("2014-07-01 00:00:00","2014-07-01 10:15:00")
  4. )
  5. CR_Date[] <- lapply(CR_Date,as.POSIXct)
  6. CR_Date
  7.  
  8. # pos1 pos2
  9. #1 2014-07-01 2014-07-01 00:00:00
  10. #2 2014-07-01 2014-07-01 10:15:00
  11.  
  12. CR_Date$pos2[2] - CR_Date$pos1[2]
  13. #Time difference of 10.25 hours
  14. CR_Date$hours <- CR_Date$pos2 - CR_Date$pos1
  15.  
  16. #Time differences in secs
  17. #[1] 0 36900
  18.  
  19. # pos1 pos2 hours
  20. #1 2014-07-01 2014-07-01 00:00:00 0 secs
  21. #2 2014-07-01 2014-07-01 10:15:00 36900 secs
  22.  
  23. CR_Date$hours <- with(CR_Date, difftime(pos2,pos1,units="hours") )
  24. CR_Date
  25.  
  26. # pos1 pos2 hours
  27. #1 2014-07-01 2014-07-01 00:00:00 0.00 hours
  28. #2 2014-07-01 2014-07-01 10:15:00 10.25 hours
  29.  
  30. CR_Date$hours <- as.numeric(CR_Date$pos2 - CR_Date$pos1, "hours")
  31. CR_Date
  32.  
  33. # pos1 pos2 hours
  34. #1 2014-07-01 2014-07-01 00:00:00 0.00
  35. #2 2014-07-01 2014-07-01 10:15:00 10.25
  36.  
  37. as.numeric(CR_Date$pos2 - CR_Date$pos1, "mins")
  38. #[1] 0 615
  39.  
  40. as.numeric(CR_Date$pos2 - CR_Date$pos1, "days")
  41. #[1] 0.0000000 0.4270833
Add Comment
Please, Sign In to add comment