Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   Contact Center Applications (http://support.avaya.com/forums/forumdisplay.php?f=3)
-   -   CMS aux reports to Excel - issue with formatting time (http://support.avaya.com/forums/showthread.php?t=12524)

clantb 04-03-2017 06:15 PM

CMS aux reports to Excel - issue with formatting time
 
I have a bunch of aux reports I want to put into Excel and be able to run a pivot table to find out how often people are over on lunch and break and stuff of that nature. However, I can't get excel to sum up the time. It works ok for hours but not for minutes.

I can do a bunch of formulas in Excel to format the data ok but I was hoping not to have to do that.

Anyone here doing this and maybe have a better method?

shaikht 04-12-2017 11:51 PM

Hi,

May be you can design report having format change in it for that column.

I hope it helps.

johns1224 05-13-2017 03:16 AM

Thanks for your suggestion, shaikt!

marzahn 05-16-2017 07:26 AM

Did You Resolve the Issue? How?
 
Quote:

Originally Posted by johns1224 (Post 31037)
Thanks for your suggestion, shaikt!

If you would, please explain the fix/work-around. I'm sure others would like to know. Particularly how you use pivot tables. That is good stuff to know.:D


All times are GMT -7. The time now is 02:30 AM.