Incident SLA report in excel

vat2do · ‎01-12-2025

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

shamil-ibrahim · ‎01-12-2025

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.

View solution in original post

vat2do · ‎01-13-2025

Dear @shamil-ibrahim

Thanks for the solution. Appreciated.