Results 1 to 7 of 7

Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    3

    Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range

    Hi, I need to aggregate the time data (mm/dd/yyyy:hh:mm:ss) into an hourly range.

    So, basically if I have ~16 observation for 2 days, I want to aggregate them into a 3 hours range window and count the number of observations in each range (of 3 hours). Example is given below. Thank you very much in advance.


    Raw Data 3 hour range Count
    09/08/2013:23:46:41 09/08/2013:03:00:00 0
    09/08/2013:23:50:19 09/08/2013:06:00:00 0
    09/08/2013:23:50:46 09/08/2013:09:00:00 0
    09/09/2013:00:27:04 09/08/2013:12:00:00 0
    09/09/2013:00:45:20 09/08/2013:15:00:00 0
    09/09/2013:00:45:21 09/08/2013:18:00:00 0
    09/09/2013:00:45:21 09/08/2013:21:00:00 0
    09/09/2013:00:45:21 09/08/2013:24:00:00 3
    09/09/2013:00:45:21 09/09/2013:03:00:00 13
    09/09/2013:00:45:21 09/09/2013:06:00:00 0
    09/09/2013:00:45:21
    09/09/2013:00:45:21
    09/09/2013:00:45:21
    09/09/2013:00:45:21
    09/09/2013:00:45:21
    09/09/2013:00:45:21
    Last edited by Trader1011; 09-20-2013 at 03:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours
    By noobface in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-21-2021, 03:45 AM
  2. Aggregate data in a range of columns to remove blank cells
    By arbgd1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 04:11 PM
  3. Replies: 7
    Last Post: 11-18-2012, 02:28 PM
  4. [SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB
    By Boormo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2012, 05:48 PM
  5. Copy+Paste macro dd/mm/yyyy to dd/mm/yyyy and NOT dd/mm/yyyy to mm/dd/yyyy
    By uimhirADo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2012, 03:45 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