title: Excel date/time difference
body: <p>I would like to work out the current time since a date and time specified.</p>
  
  <p>If the specified data is : <code>19/01/2013 16:44:00</code><br>
  and now the time is : <code>19/01/2013 16:45:00</code></p>
  
  <p>the difference is 0 years 0 months 0 days 0 hours 1 minute 0 seconds</p>
  
  <p>This can be done easily just by taking the current time and minus the previous time and format it but this is hard to crunch data so what I wish to do is break each date/time segment into its own cell</p>
  
  <p>Let's say cell A1 has the previous time and cell A2 has the current time</p>
  
  <p>Cells a5 trough f5 would contain 0 years 0 months 0 days 0 hours 1 minute 0 seconds</p>
  
  <p>On a second note on this question is it possible to force the <code>=NOW()</code> to update every x seconds via VBA without interaction?</p>