Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 0.78 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Processing Timebased values
  2. 20/Dec/2011:10:16:29 9
  3. 20/Dec/2011:10:16:30 13
  4. 20/Dec/2011:10:16:31 13
  5. 20/Dec/2011:10:16:32 9
  6. 20/Dec/2011:10:16:33 13
  7. 20/Dec/2011:10:16:34 14
  8. 20/Dec/2011:10:16:35 6
  9. 20/Dec/2011:10:16:36 7
  10. 20/Dec/2011:10:16:37 16
  11. 20/Dec/2011:10:16:38 5
  12. 20/Dec/2011:10:16:39 7
  13. 20/Dec/2011:10:16:40 15
  14. 20/Dec/2011:10:16:41 12
  15. 20/Dec/2011:10:16:42 13
  16. 20/Dec/2011:10:16:43 11
  17. 20/Dec/2011:10:16:44 6
  18. 20/Dec/2011:10:16:45 7
  19. 20/Dec/2011:10:16:46 9
  20. 20/Dec/2011:10:16:47 14
  21. 20/Dec/2011:10:16:49 6
  22. 20/Dec/2011:10:16:50 11
  23. 20/Dec/2011:10:16:51 15
  24. 20/Dec/2011:10:16:52 10
  25. 20/Dec/2011:10:16:53 16
  26. 20/Dec/2011:10:16:54 12
  27. 20/Dec/2011:10:16:55 8
  28.        
  29. =DATEVALUE(LEFT(A2,SEARCH(":",A2)-1))+TIMEVALUE(RIGHT(A2,LEN(A2)-SEARCH(":",A2)))
  30.        
  31. =C2-SECOND(C2)/24/60/60
  32.        
  33. =D2-MINUTE(D2)/24/60
  34. =E2-HOUR(E2)/24
create a new version of this paste RAW Paste Data