CCMA6 Agent Performance Report

[p26974]

Hi

Am new to Nortel and am currently working with the CCMA6 reports for the first time. I am trying to build a template in Excel which reads data from the Agent Performance Report, but the reported times (ie, Talk Time etc) are exported in text format.

Is there a way of exporting the data in a format which Excel recognises as time, rather than text, in order that the data can be used in calculations?

Thanks in anticipation

 

[Utreg]

Maybe this will help:
Export a report to an "Excel (Data Only)" file, select the whole Excel column where time appears and set the 'cell properties' to 'time'.

 

[bajangsa]

Why work with the standard report - how about ODBC directly from Excell to the AgentPerformanceStat table - then you will get the times in seconds, which you can format in Excel as you please.