I am very new to excel and cannot figure out how to take a group of times throughout a single day, which correspond to events in that day, and graph how many events occur during each hour of the day. In other words, I want a bar graph with hrs 0 through 24 on the x axis, and events on the y axis, but my original data set is presented as the actual event time, not events per hour. I need excel to calculate the number of events between 9 and 10, 10 and 11, etc., and then graph that.
My other problem is that my data arrives in the format "8/7/2012 9:12:01 AM". Is there any way I can get excel to ignore the date and just focus on the time without me having to manually cut out the date in every cell?
Please help, and feel free to take it down to a very basic level, as using formulas in excel is not yet intuitive. Thank you.
HOUR
function will give you the hour from the time. Go from there.COUNTIF
.