Genesys Cloud - Main

For queue performance, when looking at the screen it shows the information in HH:MM:SS format, which is great.  When I download the information it converts it to a whole number.  My issue is I can't figure out the conversion.  I try to put it back into HH:MM:SS for reporting purposes and I can't get the same information that I see on the screen. 
Does anyone know the conversion that is used to get the downloaded information?

For Example
Average Talk

#Reporting/Analytics

------------------------------
Nicole Waiksnoris
PricewaterhouseCoopers LLP
------------------------------

The value is in milliseconds, not seconds.  1 second = 1000 milliseconds.
395119 milliseconds = 395.119 seconds = 6m 35s 119 ms

------------------------------
Melissa Bailey
Genesys - Employees
------------------------------

Original Message:
Sent: 01-31-2019 09:35
From: Nicole Waiksnoris
Subject: Downloading Queue Performance

For queue performance, when looking at the screen it shows the information in HH:MM:SS format, which is great.  When I download the information it converts it to a whole number.  My issue is I can't figure out the conversion.  I try to put it back into HH:MM:SS for reporting purposes and I can't get the same information that I see on the screen.
Does anyone know the conversion that is used to get the downloaded information?

For Example
Average Talk

6m 35s = 395119

Average Hold
2m 24s = 144081

#Reporting/Analytics

------------------------------
Nicole Waiksnoris
PricewaterhouseCoopers LLP
------------------------------

Thank you so much!!

------------------------------
Nicole Waiksnoris
PricewaterhouseCoopers LLP
------------------------------

Original Message:
Sent: 01-31-2019 10:10
From: Melissa Bailey
Subject: Downloading Queue Performance

The value is in milliseconds, not seconds.  1 second = 1000 milliseconds.
395119 milliseconds = 395.119 seconds = 6m 35s 119 ms

------------------------------
Melissa Bailey
Genesys - Employees

Original Message:
Sent: 01-31-2019 09:35
From: Nicole Waiksnoris
Subject: Downloading Queue Performance

For queue performance, when looking at the screen it shows the information in HH:MM:SS format, which is great.  When I download the information it converts it to a whole number.  My issue is I can't figure out the conversion.  I try to put it back into HH:MM:SS for reporting purposes and I can't get the same information that I see on the screen.
Does anyone know the conversion that is used to get the downloaded information?

For Example
Average Talk

6m 35s = 395119

Average Hold
2m 24s = 144081

#Reporting/Analytics

------------------------------
Nicole Waiksnoris
PricewaterhouseCoopers LLP
------------------------------

If you are wanting to see those values as hh:mm:ss I created a macro that quickly does the conversion.  You just highlight all the columns in Excel.  See this post for instructions.  

https://community.genesys.com/communities/community-home/digestviewer/viewthread?GroupId=19&MessageKey=c9d4f41d-5853-4bc6-88fa-9428ff69a19c&CommunityKey=bab95e9c-6bbe-4a13-8ade-8ec0faf733d4&tab=digestviewer


------------------------------
Darlene Oordt
Sr Director, Product Management
Genesys - Employees
------------------------------

Original Message:
Sent: 01-31-2019 09:35
From: Nicole Waiksnoris
Subject: Downloading Queue Performance

For queue performance, when looking at the screen it shows the information in HH:MM:SS format, which is great.  When I download the information it converts it to a whole number.  My issue is I can't figure out the conversion.  I try to put it back into HH:MM:SS for reporting purposes and I can't get the same information that I see on the screen.
Does anyone know the conversion that is used to get the downloaded information?

For Example
Average Talk

6m 35s = 395119

Average Hold
2m 24s = 144081

#Reporting/Analytics

------------------------------
Nicole Waiksnoris
PricewaterhouseCoopers LLP
------------------------------