title: Matching up differing timestamp conventions across device data
body: <p>I need to analyse some data, stored in csv files. Each file represents the output of 3 devices, each with a different data sampling rate and a different time stamping convention. I would like to match timestamps from each csv file so that I can collate all the data from a single subject into a single file and use that to put into R.</p>
  
  <p>The different timestamp conventions are below</p>
  
  <p>Device 1 (Galvanic skin response):</p>
  
  <pre><code>04/12/2012 14:17
  </code></pre>
  
  <p>Device 2 (Heart rate monitor):</p>
  
  <pre><code>14:16:13
  </code></pre>
  
  <p>Device 3 (the actual task we are asking subjects to perform):</p>
  
  <pre><code>134941
  </code></pre>
  
  <p>Which I think means 13:49:41. </p>
  
  <p>I know the dates each experiment was performed on, so it's just the times I need to match against. </p>
  
  <p>The data represent heart rate, galvanic skin response of subjects and the result of the user input to the tablet. I need to correlate their performance on the task with the changes in skin conductivity and heart rate - hence why I need to match up these times. </p>
  
  <p>For example, there is a single file per person for skin response and a separate one heart rate but multiple files (with similar times) for the performance on our task depending on the various experimental conditions we used. I'd rather not do this matching task personally as there are ~ 300 of these files.</p>