+ Reply to Thread
Results 1 to 3 of 3

Generate a list number of visits at different times in a day

  1. #1
    Registered User
    Join Date
    08-14-2012
    Location
    Sydney
    MS-Off Ver
    Microsoft 365
    Posts
    90

    Generate a list number of visits at different times in a day

    I want to graph the number of visits we receive at different times throughout the day in half hour increments. The times are recorded in hours and minutes for each individual visit. How can I generate a list that counts the number of visits for example between say from 10:00AM to 10:29AM, 10:30AM to 10:59AM, 11:00AM to 11:29AM and so on for the whole day? My apologies if this is the wrong place to post this question.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Generate a list number of visits at different times in a day

    Hard to be specific without seeing sample data, but I think you need to use the countifS() function
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    09-07-2006
    Posts
    520

    Re: Generate a list number of visits at different times in a day

    One idea ..
    Assume your source time data is in A2:A10

    Input
    in C2: 10:00 AM
    in C3: 10:30 AM
    Select C2:C3, copy down

    Then place
    in D3: =TEXT(C2,"h:mm AM/PM")&"-"&TEXT(C3,"h:mm AM/PM")
    in E3: =SUMPRODUCT(($A$2:$A$10>=C2)*($A$2:$A$10<C3))
    Copy D3:E3 down. Now you can graph it based on col D (time bucket labels) and col E (counts)
    ---------------------------------
    Any good? Wave it, hit the little star at the bottom left of my responses

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Repeat Names on a list depending on how many visits
    By Dave69rock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2013, 04:17 PM
  2. Generate multiple lists without the same last and first number of each list...
    By Dreamweaver8882004 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2013, 08:49 PM
  3. Display Total number of visits for each postcode
    By fetster in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2013, 12:43 PM
  4. Generate a unique number of list
    By Terence Chan in forum Excel General
    Replies: 3
    Last Post: 09-14-2005, 02:48 AM
  5. Replies: 0
    Last Post: 08-28-2005, 10:37 AM

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