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

Discussion in 'Excel Beginners' started by trader1011, Sep 20, 2013.

  1. trader1011

    trader1011 Guest

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

    So, basically if I have 10 observation 7 days, I want to put them into the 3 hours range window and see that how many observations I get on 3 hours basis. Example is given below. Thank you very much in advance.

    09/08/2013:23:46:41 09/08/2013:03:00:00
    09/08/2013:23:50:19 09/08/2013:06:00:00
    09/08/2013:23:50:46 09/08/2013:09:00:00
    09/09/2013:00:27:04 09/08/2013:12:00:00
    09/09/2013:00:45:20 09/08/2013:15:00:00
    09/09/2013:00:45:21 09/08/2013:18:00:00
    09/09/2013:00:45:21 09/08/2013:21:00:00
    09/09/2013:00:45:21 09/08/2013:24:00:00
    09/09/2013:00:45:21 09/09/2013:03:00:00
    09/09/2013:00:45:21 09/09/2013:06:00:00
    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
     
    trader1011, Sep 20, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. cc
    Replies:
    1
    Views:
    107
    Peo Sjoblom
    Mar 27, 2006
  2. Jack Wilson
    Replies:
    4
    Views:
    156
    Jack Wilson
    Jul 18, 2006
  3. TWERNER
    Replies:
    2
    Views:
    180
    SteveW
    Aug 21, 2006
  4. thomsonpa
    Replies:
    4
    Views:
    202
    Bernard Liengme
    Dec 3, 2007
  5. bbane

    format cells from mm/dd/yyyy to yyyy

    bbane, Apr 1, 2009, in forum: Excel Beginners
    Replies:
    3
    Views:
    127
    bbane
    Apr 2, 2009
  6. okey

    DD-MON-YYYY never D-MON-YYYY

    okey, Aug 5, 2009, in forum: Excel Beginners
    Replies:
    1
    Views:
    174
  7. Jon C.
    Replies:
    1
    Views:
    79
    Niek Otten
    Feb 10, 2010
  8. Thomas

    Change format to mm dd yyyy hh mm ss

    Thomas, Mar 4, 2010, in forum: Excel Beginners
    Replies:
    1
    Views:
    97
    Niek Otten
    Mar 4, 2010
Loading...