Posted: 15 Oct 2020 12:59 EDT Last activity: 15 Oct 2020 13:10 EDT
TimeElapsed-HMS doesn't show as date/time format when exported to excel
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!