1 Reply Latest reply: Feb 12, 2013 11:29 AM by Stefan Wühl RSS

    Time Tracking of Meetings

      Hi

       

      Not really sure where to start with this challenge.

       

      I am trying to track occupancy levels of meeting rooms in a Community Centre.

       

      I have data which has a start time and end time - all meetings are same day i.e. none span midnight. I need to show the utilization of a meeting room i.e.

       

      Meeting Room           Start Time          End Time

      Room 1                    9:00                    11:00

      Room 1                    13:00                   15:00  

       

      I would like to see a chart hour by hour of a day that shows in the above example between the hours of 11:00 and 13:00 it was empty.

       

      Additionally some meetings may be on the half hour ? If that makes a difference to the challenge.

       

      As I say I not sure where to start with this one so would appreciate any support that be offered,

       

      Many thanks,


      Rob