Question on Report

[Maddysunil]

Hello everyone,

I have a report on database view table(sn_hr_core_case_workforce_task_sla_db_view) created between two table (n_hr_core_case_workforce_admin and task_sla). There is field on report "Business elapsed time" . On report it is showing fine like (3 Days 3 Hours 18 Minutes 0 Seconds) but when report is exported that same field is showing in number(271080) in excel. How to fix this? Screenshot attached

 Note: I tried below approach but not working:

https://www.servicenow.com/community/itsm-forum/business-elapsed-time-when-exported-to-excel-is-show... 

Check if below property is available or not if not then Create the following sys_property:

1. Go to the system property : sys_properties.list

2. Click on New and add below details

Name: 'glide.ui.duration.seconds.enabled'

Type: true | false

Value: true

[AndersBGS]

Hi @Maddysunil ,

This is how it is exported to Excel. you instead need to utilize this formula in Excel to convert the time: "=CONCATENATE(TEXT(INT(A1)/86400;"tt:mm:ss"))".

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

best regards

Anders

[Maddysunil]

@AndersBGS 

Thanks for your response, Actually i am looking for some solution which should work without applying formula.

[Dr Atul G- LNG]

You can do in excel easily but not in SN.

[Sumanth16]

Hi @Maddysunil ,

Duration field (the Actual elapsed time column) is formatted as Days, Hours, Minutes (e.g. 838 Days 19 Hours 46 Minutes). This is the expected behavior.

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

https://www.servicenow.com/community/developer-forum/reports-exported-to-excel-must-show-hrs-min-sec...

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda