Business time left in export to excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2022 12:39 PM
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?
I wonder if anyone has tried another way to solve this case other than using a script?
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2022 05:04 PM
Hi Michelle,
Not sure it can be easily done in ServiceNow, but you may fix this in the Excel file.
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0656030
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2022 05:09 PM
More solutions here: https://community.servicenow.com/community?id=community_question&sys_id=3eefc7a5dbdcdbc01dcaf3231f961993
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-17-2022 03:59 AM
Thanks, but it doesn't help me because the report will be sent directly to the client by email, so this option to change it in excel is not a desired option
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-17-2022 04:40 AM - edited ‎09-05-2023 07:09 AM
That's awesome information I got from here.
