title: How to reduce time interval and average observations?
body: <p>I have two columns of data: a time column in the format DD/MM/YY HH.MM and a column with binary data for each time cell, eg: </p>
  
  <pre>Time                Set
  2015-01-02 14:39:35 0
  2015-01-02 14:39:36 1
  2015-01-02 14:40:11 0
  2015-01-02 14:40:50 1
  2015-01-04 07:53:47 0
  2015-01-04 07:54:17 1
  2015-01-04 12:18:02 0</pre>
  
  <p>I would like to change the time interval to a fixed one, say five minutes, and show the average value of the observations in this interval.</p>
  
  <p>Is there some way this can be done in Excel with filtering or VBA macro, or perhaps in R?</p>
  
  <p>I hope it is possible to help without any reproducible code.</p>