Results 1 to 6 of 6

How do I? Hour by Hour Occurrences between a Date Range?

Threaded View

lesoies How do I? Hour by Hour... 02-05-2013, 07:09 PM
Pete_UK Re: How do I? Hour by Hour... 02-05-2013, 07:45 PM
lesoies Re: How do I? Hour by Hour... 02-06-2013, 04:53 PM
Pete_UK Re: How do I? Hour by Hour... 02-06-2013, 07:30 PM
lesoies Re: How do I? Hour by Hour... 02-06-2013, 08:44 PM
Pete_UK Re: How do I? Hour by Hour... 02-06-2013, 09:01 PM
  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    How do I? Hour by Hour Occurrences between a Date Range?

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1