duration fields in export to excel

[auntyem]

I've already found this in the wiki:

5.1 Excel
Date, Date-Time, and Time fields are all exported as their display values, displayed using a custom format instead of the system date format. Duration fields, however, export as the value stored in the database, which is an integer value of seconds.

The last part about duration fields in seconds is REALLY undesirable; customers are complaining that the report is useless. Is there a way to configure this to be something friendly like hours?

Thanks!

[cag_onganer]

Hi Nabeel,

Thanks for your update and raising an incident to Support as well. We can't commit a release but it is definitely in the roadmap. The more comments I can get on this thread, the more demand I can show. So please comment if you are interested.

Regards,

Cag Onganer

[na93]

Thanks Cag, much appreciated.

[Luis Franco]

For me I would just need a new date format like in excel [hh]:mm for date time fields. It doesn't make any sense showing the Business Duration Time which represent 8h per day:

in a format that shows 3 days instead of 72h + 17h = 89h 4 minutes.

Do you now a way to do this?

Thank you.

[raghu59]

Workaround is here

https://hi.service-now.com/kb_view.do?sysparm_article=KB0656030

[Vik7]

Easy work around would be export to PDF and then convert to excel sheet.

Thanks,

Vik.