4 Replies Latest reply: Jul 21, 2015 9:00 PM by Ryan Minaker RSS

    How to average hours between a start and end date?

    Ryan Minaker

      I'm wondering if anyone can help me with creating a chart that will show hours averaged over the duration of a start and end date?

       

      I understand the basics of the master calendar and have created this. I've also been able to calculate the business days/hours between the start date and end date. My problem is that I can't figure out how to average the estimated hours across a span of months and get the months to show up on the chart.

       

      I've been reading though a lot of the community posts and perhaps IntervalMatch is what I need to use, but not sure how to get that to work.

       

      Thanks!

       

      Source data:

       

      StartDateEndDateEstimatedHoursProjectNameStaff
      7/1/201511/30/2015500Project ABill
      8/1/201509/30/2015300Project BBob

       

      What I'd like my chart to look like:

       

      b3397c6abf7341dda53884fd4dd6f02d.png