- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2025 10:01 PM - edited 01-12-2025 10:02 PM
Greetings to all,
A quick question. whenever i am downloading incident report from SLA_Incident table in excel format, i am receiving a random number under column "Business elapsed time" for example -check the attachment, instead of "days-hours-minutes-seconds". Is there any workaround to solve the issue.
Thanks in advance.
Regards
Solved! Go to Solution.
- Labels:
-
Incident Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2025 11:19 PM
Please use the below excel formula to convert seconds to days, hours, minutes and seconds format.
=TEXT(A1/(24*60*60),"dd \d\a\y\s hh:mm:ss")
*replace "A1" with the cell number where your seconds data is. see attached image.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2025 10:38 PM
that's OOB behavior for duration field. it's time in seconds
If you want to change or customize anything , here is mentioned couple of ways:
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0656030
OR check this link and you can convert that in excel
After export to Excel "Actual elapsed time" is showing number what does it mean
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2025 10:39 PM
Hello @vat2do ,
Business elapsed time is actually a Duration time field.
You can take help from the below thread to solve this issue:
https://www.servicenow.com/community/developer-forum/how-to-convert-duration-type-field-to-show-hh-m...
If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2025 11:09 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2025 11:19 PM
Please use the below excel formula to convert seconds to days, hours, minutes and seconds format.
=TEXT(A1/(24*60*60),"dd \d\a\y\s hh:mm:ss")
*replace "A1" with the cell number where your seconds data is. see attached image.