2 Replies Latest reply on Mar 22, 2013 10:31 AM by Susan Oner

    Issue with calculating flow based on time intervals

    Susan Oner

      I have data with start times for a specific action that goes on until the next start time for the next action.  I'd like to chart this flow over time (like in a gantt chart with colored boxes for the different actions), but I'm having an issue with getting the correct view (dates are wonky).  Also there is additional information related to these actions that I'd like to see (ie the responsible payer at any given moment in time).

       

      A sample workbook is attached, any help would be appreciated.

       

      Thank you,

      Susan