Exported report is showing values in seconds

[RakshithS]

When we generate report from task_sla table, fields such as Duration, Business Elapsed time display values in hours / minutes / seconds. However if we export same report, then those values are displayed in seconds. How can we export same data which is displayed in report?

Regards

Rak**bleep**h

[Ankur Bawiskar · Accepted solution]

@RakshithS 

those fields are duration type so they will always give value in milliseconds

Couple of ways

1) Workaround is to use PDF rather than Excel or CSV

OR

2) create a custom field which holds string value of that duration and use that in reporting

After export as Excel time fields are showing seconds but i want to see it in only Hours and Minutes 

OR

3) try to see if you can use function field in report and convert the milliseconds to hours

OR

4) inform user to apply Formula in Excel and convert that, response from Jeff

How to display duration field value in a proper format in an excel report 

If my response helped please mark it correct and close the thread so that it benefits future readers.