CMS aux reports to Excel - issue with formatting time

[clantb]

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]

Hi,

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

I hope it helps.

[johns1224]

Thanks for your suggestion, shaikt!

[marzahn]

Originally Posted by johns1224

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.