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

[Vaishnavi35]

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 · Accepted solution]

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

[AbhishekGardade]

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

[Vaishnavi35]

Hi Abhishek,

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

[Ankur Bawiskar]

Hi,

Open the form and check what value it shows; possibly there would be extra info such as seconds along with the minutes

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