Exported report is showing values in seconds

[Prasad Marade1]

When we generate report from incident_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?

Thanks in advance!

[manikorada]

Prasad,

I think it is the default behavior where the export will show seconds. I don't know if there is any setting which can achieve your functionality

[randrews]

you really can't prevent this.. the values are actually stored as a seconds value.. and then converted to a viewable format when rendered... what i have done in the past was use an excel formula to convert the values and just copy the report into that master for that report.

[Avinash Shawdar]

Hi everyone,

    Here is a question with further explanations that treats this same subject: https://community.servicenow.com/community?id=community_question&sys_id=3eefc7a5dbdcdbc01dcaf3231f96....

Best regards,

FIKRI BENBRAHIM Mohamed Jawad

[Armitage Doktra]

Hello prasadmarade,

I had worked on the same issue as this one and i had found out that report on a table or database view with duration fields are displayed in reports as 21 days 12 hours as an example but once exported to an excel sheet, they get displayed as integers representing the number of seconds instead of x days x hours.

See this link to know more about it: https://community.servicenow.com/community?id=community_question&sys_id=3eefc7a5dbdcdbc01dcaf3231f96....