After export to Excel "Actual elapsed time" is showing number what does it mean

[kranthi2]

Hi,

After export to Excel "Actual elapsed time" is showing number in the Excel what does it mean ?

Please help me out with the difference.

Thanks,

[AndersBGS]

Hi @kranthi2 ,

It's the same time in seconds. This is default behavior when you export to Excel.

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

Best regards

Anders  

[kranthi2]

In Excel is it possible to put only Hours and Minutes

which means HH:MM (please help me out the configuration),

Thanks,

[AndersBGS]

Hi @kranthi2 

Just create a calculation in Excel as below:

Where E8 is the actual elapsed time. 

Afterwards Format the number as below:

This will give you the result:

Just like ServiceNow:

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

Best regards

Anders  

[kranthi2]

1. In the above screenshot i see that Days are also included but i want only Hours and minutes.

HH:MM format only.

and one more question

2. Any possibility can we done some modifications in Servicenow only ? then we can export excel ?