title: How to auto fill cell C with a formula that only returns the date from cell a?
body: <p>Currently my google spreadsheet has cell <code>B</code> &amp; <code>A</code> which contains my timestamp and temperature value which I send from my Arduino. I am unable to display it out on my google chart because it only takes in number range filter or date range filter, so I have to convert the timestamp to only a time as the date is not important.</p>
  
  <p>I created a formula in cell <code>C</code> which is <code>=int(A2)</code> which returns me the date, and in cell <code>D</code> <code>=C2-A2</code> which returns me the actual time that I wanted to use in my google chart. But when my arduino sends a new timestamp and temp value, the cells <code>C</code> and <code>D</code> do not auto update and convert for me.</p>
  
  <p>Is there anything I can do to make cell 'C' and 'D' auto calculate and do the formula when my Arduino sends new data? </p>