title: How to import timestamps & durations in HH:MM:SS format from excel in R?
body: <p><p>
  I have an <b>excel table</b>that has a <b>column</b> that contains <b>timestamps</b> in the format <code>HH:MM:SS</code>.<br>
  However, after reading in the exported <b><code>CSV</code></b> into <b>R</b>, the values in the corresponding column <code>data$timestamp</code> are interpreted as a <s>huge</s> small number (e.g., <code>7,06018515869254E-04</code>.)<p>
  How can I get <b>R</b> to interpret the numbers as they were meant to?<p>
  I've tried the following without any success (yield <code>NA</code>):</p>
  
  <pre><code>timeTest &lt;- data$timestamp[1] 
  print(as.POSIXct((timeTest - 719529)*86400, origin = "1970-01-01", tz = "UTC"))
  print(as.POSIXct(strptime(timeTest, %Y%m%d %H%M%S")))
  </code></pre>
  
  <p>A hint how to achieve the desired format would be of great help! </p>
  
  <p><hr>
  Here is a sample from the actual <code>CSV</code>:</p>
  
  <pre><code>0,692210648148148|0,692534722222222|3,24074074074088E-04
  </code></pre>
  
  <p>As I use <code>|</code> as separator, I import the data as follows:</p>
  
  <pre><code>data &lt;- read.delim(file,header=TRUE,sep="|")
  </code></pre>