title: Data Chart to show times of day in Excel
body: <p>I have a data set where by i am required to show the sum of calls for a date and their call times also.</p>
  
  <p>Here is an example of my data set for a few days for one extension</p>
  
  <p>6/24/11 7:43:38 AM 
  6/24/11 8:10:23 AM 
  6/24/11 8:16:54 AM 
  6/24/11 8:20:45 AM 
  6/24/11 4:47:06 PM 
  6/25/11 12:38:43 PM 
  6/25/11 5:38:10 PM
  6/26/11 7:32:53 AM 
  6/27/11 5:40:32 PM 
  6/28/11 3:46:05 PM 
  6/29/11 7:09:21 PM 
  6/30/11 5:59:54 AM 
  6/30/11 1:21:28 PM 
  6/30/11 5:59:00 PM</p>
  
  <p>Is it possible to put this into a chart whereby we can see a sum of calls for a given date? If that makes sense.</p>
  
  <p>Thanks,c</p>
  
  <p>-=</p>
  
  <p>I found the following post at <a href="https://stackoverflow.com/questions/200667/excel-timesheet">Excel Timesheet</a></p>
  
  <p>this fixed my problem.</p>