Hi Guys,
I have an Excel that I need help with. These dates represent the number of email submissions I got on my website. I'm trying to find out how to see what hours of the day are most popular.
a) I need Excel to give me an hourly breakdown of submissions.
b) I would also like to be able to enter a date range, so that I can enter say "Between November and December".
c) If I can also enter a specific day to see breakdowns for that day only, such as Tuesday's, that would be great.
Attached is an Excel. Any help is appreciated!
For example:
Date Start:
Date End:
Hourly breakdown:
12am to 1am: Submissions
1am to 2am: Submissions
2am to 3am: Submissions
etc.
This is an example of how Column A looks in my Excel.
1/28/13 11:08 AM
1/26/13 6:08 PM
1/25/13 11:51 AM
1/24/13 8:36 PM
1/24/13 2:47 PM
Bookmarks