Incident SLA report in excel

[vat2do]

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

[Ankur Bawiskar]

@vat2do 

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.

[Najmuddin Mohd]

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.

[shamil-ibrahim]

You can use the below formula to apply the formatting in excel to convert second into "dd Days hh:mm:ss" format:

=TEXT(A1/(24*60*60),"dd \d\a\y\s hh:mm:ss")

In the above excel formula replace "A1" with the cell number where your seconds data is.

See the image attached.

[shamil-ibrahim · Accepted solution]

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.