Results 1 to 12 of 12

Count frequency of set hour ranges from large list of times

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    SD
    MS-Off Ver
    Excel 2008 Mac
    Posts
    12

    Question Count frequency of set hour ranges from large list of times

    I have a large list of date/time stamps (over 8000). I am just concerned with the time portions. I need to summarize how many records appeared within a certain hour block.
    Example:

    Hour / Frequency
    04:00-04:59 / 200
    05:00-05:59 / 150
    06:00-06:59 ...
    19:00-19:59
    08:00-08:59
    09:00-09:59
    10:00-10:59
    11:00-11:59
    12:00-12:59

    Attached is a sample of the data (just 100 records) I am working with. This is part of a much larger spreadsheet so I mainly need the correct formula(s). My range of date/times I need to work from is listed in tab "times" column B. The hour ranges I need to count can be found in tab "frequency".
    Last edited by samchargers09; 02-26-2010 at 07:14 PM. Reason: Solved.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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