+ Reply to Thread
Results 1 to 2 of 2

aggregating time while count values

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    aggregating time while count values

    Hi - good to meet everyone and thank you for your help in advance
    My issues is - i would like to group the time in column c ( in 5 min intervals) and count the values in column d during those 5 minute time aggregation
    so per sample data below or file attached the time between 0:00 and 03:04 would be the first 5 min and I would get a count of 7 ( the amount of 100 that occurred during that first 5 min )
    what is the best way I can achieve this - thanks

    site Date Time Code
    4 3/18/2014 00:38.0 100
    4 3/18/2014 00:46.0 100
    4 3/18/2014 01:50.0 100
    4 3/18/2014 02:14.0 100
    4 3/18/2014 02:25.0 100
    4 3/18/2014 02:37.0 100
    4 3/18/2014 03:04.0 100
    4 3/18/2014 05:39.0 100
    4 3/18/2014 05:53.0 100
    4 3/18/2014 05:58.0 100
    4 3/18/2014 06:32.0 100
    4 3/18/2014 13:42.0 100
    4 3/18/2014 14:36.0 100
    4 3/18/2014 17:06.0 100
    4 3/18/2014 28:22.0 100
    4 3/18/2014 28:33.0 100
    4 3/18/2014 28:43.0 100
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: aggregating time while count values

    Welcome to the forum.

    Mod Note: To other mod . Thread has already copy in subforum.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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. Create a Time Range off Time Stamps, and Count Intersecting values
    By athyeh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2014, 05:07 PM
  2. Count Unique Values Of A Cell over time
    By samsonuk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2013, 04:46 AM
  3. [SOLVED] Aggregating Data by Unique Value and Sub-Values
    By jablo1312 in forum Excel General
    Replies: 4
    Last Post: 06-08-2012, 10:44 AM
  4. Aggregating Time Series Data
    By j0rge in forum Excel General
    Replies: 3
    Last Post: 03-27-2012, 04:38 PM
  5. Aggregating by time
    By andykent99 in forum Excel General
    Replies: 2
    Last Post: 01-21-2012, 08:41 PM

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