title: What is the best way to count time durations in CSV file?
body: <p>I have  following kind of data in CSV file:</p>
  
  <pre><code>1; 28.11.2014 3:2:43; 
  0; 28.11.2014 3:3:58; 
  1; 28.11.2014 5:31:36; 
  0; 28.11.2014 5:33:7; 
  2; 28.11.2014 7:10:40; 
  0; 28.11.2014 9:50:10; 
  ...
  </code></pre>
  
  <p>What I am trying to do is count how long each status flag is up and then sum these amounts. In example; flag 1 is up 75 seconds (row 1), etc.. Would it be most effective to count all times between rows at first (place then somewhere) and then sum up times or somehow else?</p>