+ Reply to Thread
Results 1 to 2 of 2

Filter column data by time interval and count the number of records for each interval

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Beijing
    MS-Off Ver
    Excel 2013
    Posts
    1

    Filter column data by time interval and count the number of records for each interval

    Hi all,

    I have a column of "timestamp" data (in mins) which i want to filter by a given time interval, say 10 mins. Then i want to count the number of records for each time interval and output the data to a sheet. how can i achieve this? through vba? can anyone kindly provide some code?

    I attached a pic illustrating what i want to accomplish.
    thanks!

    QQ截图20140429104406.png

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Filter column data by time interval and count the number of records for each interval

    Hi,

    Please upload a sample template of your workbook with enough data in it using "Go Advanced" option. The chances of you getting a response are more when you upload a workbook rather than an image.

+ 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. Formula to count number of patients per time interval over 24 hours+
    By RM1984 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 11:30 AM
  2. How to Count number of overlapping rows within a time interval
    By czou6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2013, 04:45 PM
  3. Replies: 0
    Last Post: 04-23-2012, 10:06 AM
  4. How to count number of people per time interval
    By chinkygirl in forum Excel General
    Replies: 1
    Last Post: 02-11-2012, 01:33 PM
  5. Counting datapoints/records in time interval
    By edw@gmx.at in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-15-2005, 01:06 AM

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