Question

7
Views
Close popover
Paula Dyunco (Paula)
Accenture Inc

Accenture Inc
PH
Paula Member since 2018 4 posts
Accenture Inc
Posted: October 15, 2020
Last activity: October 15, 2020

TimeElapsed-HMS doesn't show as date/time format when exported to excel

Hi!

We are using the control TimeElapsed-HMS to show the average handling time to hh:mm:ss format. However, we've got an issue that the column is shown as General format when exported to excel. The problem is that even if we update the format in excel, the changes is not reflected and only shows count. Yes, we can do some data manipulation in excel but not all users are technical enough to do these manipulations.

Is there a way in the report definition to have the hh:mm:ss format and when exported via excel the column format will also be time format? Thank you! 

 

Exported data that is in General format

Pega Platform 8.4.2 Case Management Consumer Services System Administrator