After export to Excel "Actual elapsed time" is showing number what does it mean
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2023 11:01 PM
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2023 02:32 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2023 06:34 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2023 08:31 AM
Hi @kranthi2