title: How can I count data by group in excel
body: <p>I have data of program usage in excel file, the data has date and time. I want to summarize this information that in each day each hour, how many user use this application. How to do that using excel formular?</p>
  
  <p>sample data:</p>
  
  <pre><code>Jun 01, 09:03AM
  Jun 01, 10:00AM
  Jun 01, 10:50AM
  Jun 01, 11:00AM
  Jun 01, 11:26AM
  Jun 02, 01:00PM
  Jun 02, 03:00PM
  Jun 02, 04:04PM
  Jun 02, 08:00PM
  Jun 02, 11:00AM
  Jun 02, 12:00PM
  Jun 01, 10:50AM
  Jun 01, 11:00AM
  Jun 02, 11:00AM
  Jun 02, 12:00PM
  Jun 02, 01:00PM
  Jun 03, 08:00PM
  Jun 03, 09:00PM
  </code></pre>