Business Elapsed time when exported to Excel is showing few extra secs/millisecs

Vaishnavi35 · ‎12-03-2019

Hi,

I have created/pulled a report in Servicenow.

For a ticket the Response-time in servicenow is 14 Minutes

In Excel sheet when i export it shows extra 37 Secs.. for different records its different. Can anybody please help me with this.

Is it Seconds or Milli seconds btw??

Thanks,

Vaishnavi

AbhishekGardade · ‎12-03-2019

Hello Vaishnavi,

This is normal behaviour, though it shows you 14 minutes , but if you open this SLA record and check then it will show you complete details in Days HHMMSS as below.

The permanent fix for this issue :

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

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

Thank you,
Abhishek Gardade

View solution in original post

Vaishnavi35 · ‎12-03-2019

Hi,

I have seen other community pages there it says this is servivenow behaviour. There's some formula applied when exporting is done is what i have we cannot do anything.

I am saying about the conversion..when exported to excel...it is by default and we cant change.

Thanks,

Vaishnavi

Viral Modi · ‎10-04-2023

Hi Vaishnavi,

If i understand right, you have the business elapsed time in Excel which shows a number and you want to try and convert that into hh:mm:ss format like you see in ServiceNow.

Try dividing the business elapsed time by 86400 and just use the format cells in Excel to convert into Time [h]:mm:ss

Hopefully it should work.

Thanks,

Viral