Exported report is showing duration filed values in seconds

[ashokbodaga]

Hi ,

I created a report on  database view with duration fields are displayed in reports as 05 days 11 hours as an example but once exported to an excel sheet, they get displayed as integers representing the number of seconds instead of 05 days 11 hours.

Could you please suggest a way to export duration like days and hours other than seconds.

Thank you.

[AndersBGS]

Hi @ashokbodaga ,

This is default behavior. Please change accordingly in the Excel sheet or where ever you're exporting to.

[Syed14 · Accepted solution]

Hi,

You can achieve it by creating 'glide.export.excel.duration.readable_string' property (if not already exist) and set it to true.

[KushalaM0405144]

Can we do something similar for csv?

[Vishal Jaswal]

Hello @KushalaM0405144 

No such export set system properties for csv provided by ServiceNow: https://www.servicenow.com/docs/r/zurich/integrate-applications/system-export-sets/r_ExportSetProper...