Meeting Query - Attendee Meeting Hours

[Oliver_S_Beard]

One of our analysts here at CMI pointed out that when a meeting calculates attendee meeting hours that the definition (shown below) states the total number of adjusted meeting hours for all attendees. We assume this has calculations baked in from the attendees with conflicting meetings. Could you help us clarify how the adjusted meeting hours formula is calculated so that we can be prepared for questions that have come from our engineering organization (they like to scrutinize numbers 😉 )

[Jake_Caddes · Accepted solution]

Hi @Oliver_S_Beard, here is the definition of Adjusted meeting hours from the glossary:

The formula would be calculated as an addition/subtraction formula - in the example below there is 2 total meetings hours in question but since the person accepted both meetings and they overlap by 30 minutes the total adjusted meeting hours is 1.5 hours.

Adjusted meeting hours

An adjustment is applied so that overlapping time is not double-counted when a person has overlapping meeting hours. For example, a person with non-declined meeting requests from 2:00 to 3:00 PM and 2:30 to 3:30 PM would yield 1.5 adjusted meeting hours.

Here is the link to the glossary: Workplace Analytics Glossary | Microsoft Docs

[Oliver_S_Beard]

Thanks for the explanation. This makes good sense inside person query not to double count. How does the meeting that has conflicts calculate the attendees meeting hours from the meeting's point of view? Do the meetings equally split the overlap time between the two meetings in conflict when calculating attendee meeting hours? 

[Steve_Wilford]

Thanks Jake, this makes sense, but in the context of the meeting that is being reviewed how are the hours divided between the two meetings?

For example, per the glossary lets assume that a meeting (Meeting A) has 5 people who have accepted, two attendees have a 30 minute overlap with Meeting B that they have not declined, (Meeting A runs 2:00-3:00, Meeting B runs 2:30 - 3:30) If this overlap didn't exist, I would expect that attendee meeting hours for Meeting A would be 5 hours, is this correct?

Due to the two attendees with the clash, does the system divide the adjusted 1.5 hours for both attendees equally between the 2 meetings? Thus 45 minutes are assigned to each attendee with double bookings, so Meeting A would now record 4 hours 30 minutes Attendee Meeting Hours (1 hour + 1 hour+ 1 hour+ 45 minutes + 45minutes)?

Lets assume Meeting B only has the 2 attendees with the clash, would this meeting register 1 h 30 minutes attendee meeting hours?

Thank you