1
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.
If you can make sure that Excel recognizes the data as a date & time, the
HOUR
function will give you the hour from the time. Go from there. – Iszi – 2012-08-08T13:38:12.517Iszi,Thanks, that solved half of my problem. Now how do I get excel to count all of the events between 9:00 and 10:00, for instance, and display that as a number so I can graph the number of events during each hr of the day? In essence, I now have 11 "9:00s", 7 "10:00s", etc., and I need excel to automatically sum these and present them in a separate column so I don't have to manually do it. – GLF – 2012-08-08T14:44:03.540
Check out
COUNTIF
. – Iszi – 2012-08-08T14:51:27.400Worked like a charm. Thanks a lot for your help Iszi. – GLF – 2012-08-08T15:18:29.450
Glad it helped. I posted an answer summing up the comments, so you can up-vote and/or accept. Let me know if there's any part of your question that is not addressed. – Iszi – 2012-08-08T16:02:12.863