Hello,
I've come across some very strange behavior, apparently in all reports. (This is CMS R18). I'm using standard reports - in this case the Historical>Agent>Group Summary Monthly report.
I run the report. If I export via Edit>Export All Data and then paste that into Excel, I get an array of columns equal to what's in the report. And from my experience with custom reports, I know that the format of the columns is under my control.
But if I click and drag to select just the values in any column that's showing an amount of
time, then Ctrl-C to copy and then paste that into Excel, that single report column pastes in as
two columns. One column is the number of seconds, the other is the hh:mm:ss format. This behavior is the same whether I've checked the "Export Time Durations in Seconds" box.
This apparently happens with every column that holds a time value, across what looks to be every report. I can't find any option or parameter that affects it either way. (Admittedly, I don't have access to the CMS server itself, just the CMS Supervisor.)
Why is this happening?
Thanks,
Steve
------------------------------
Steve Charloff
Manager, Computer Assisted Coding Support
Optum360
------------------------------