While download a report as Excel Business pause duration column values should get as it is on excel.

[Mad3]

Hi,

We report created on sc_task_sla table. there is a column Business pause duration, while run the report can see the result in Days and hours and minutes. when download as Excel the days are converting into seconds. How to get rport downloaded with as it is values.

Ex: While run the report in swervicenow the values are like below

While download as Excel: the result is in secondes

Expected result is while download the report as excel, should get result like Days hours and minutes[like in servicenow].

Thanks in advance.

[Jean-Emmanuel]

Hi @Mad3,

By default you have the duration in second when exporting to excel.

You can create another column in excel with the formula [Business duration / 86400] and then choose the format Time for this new column

[Aniket Chavan]

Hello @Mad3 

Please refer to the below article.

• Duration fields in export to excel 

Also you can use the formulas in Excel to convert the seconds to hrs or days accordingly. Please let me know your views on this and if you have any further query.

Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Regards,
Aniket

[AndersBGS]

Hi @Mad3 ,

This is standard behavior when downloading to Excel, the time will be converted to seconds. 

You need to format the field in Excel and then multiply up til min, hours, days etc. for your need. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders