I've exported some queue data from the API and I'm attempting to calculate the AHT, Most of the intervals I calculated match the same stats within the Genesys Cloud App. However, some of the other intervals are off and I haven't figured out why yet. For example, One interval contains the following values:
TalkComplete.sum = 0.123273645833333
HeldComplete.sum = 0.00364011574074074
ACW.sum = 0.00104166666666667
Dialing.sum = 0.0000836805555555556
Contacting.Sum = 0.0000148148148148148Handle.count = 9
When I sum up TalkCoplete + HeldComplete + ACW + Dialing + Contacting, I get
0.128053923611111
From there, I divide that by the Handle.count and I get
0.0142282137345679
I convert that number to time duration in Excel and I get
0:20:29
What's throwing me off is that the Genesys Cloud App shows the Avg Handle as
15m 45s
Why is this working for some intervals, but not other intervals? Is there something I need to add into this calculation to make it match?