+ Reply to Thread
Results 1 to 1 of 1

Occurrences between different time periods

Hybrid View

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2007
    Posts
    79

    Occurrences between different time periods

    Hi,

    The tittle is not very descriptive, but I have no idea what could be proper terminologies. Nevertheless, I think that the file attached is explicit enough.
    For example, event B happens between 7/1/13 and 7/2/13, and between 7/1/13 and 7/5/13 as well (in 2 different processes). So it happens in total 2x on 7/1/13 and 7/2/13, and 1x between 7/3/13 and 7/5/13.
    I have not found a way using PivotTable to reach the solution that I am looking for (2nd part of the file attached). I think that the problem has to be split into 2 parts:
    -create a linear time line with the row labels (i.e 7/1, 7/2, 7/3, 7/7...).
    -count the events for a specific date.
    For both these parts, I am not even sure that this is possible. Any help would be much appreciated.

    Thanks,
    Guillaume
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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