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,

[Dr Atul G- LNG]

Hi @kranthi2 

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

HH:MM format only.

Atul: This is all about excel way of working, try your hands in number format ( Google it , you will get examples as well - convert day to Hours )

and one more question

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

Atul: No, that easy and straight forward. Seems PA can helpful but not in standard reporting.

Please accept @AndersBGS  answer as Helpful and Solution if it work, I just replied to give you update.

[AndersBGS]

Hi @kranthi2 

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

Best regards
Anders 

[Dr Atul G- LNG]

Hi @kranthi2