Excel Export Showing Duration Field in Seconds

mhafizam · ‎06-09-2025

Hi,

When exporting the data to Excel, the duration field is currently displaying in seconds. However, I would like it to show in hours and minutes only.

Could you please advise how to achieve this?

Thank you in advance for your support.

Ankur Bawiskar · ‎06-10-2025

@mhafizam

that's the out of the box behavior

the field is duration type so they will always give value in milliseconds

Couple of ways

1) Workaround is to use PDF rather than Excel or CSV

OR

2) create a custom field which holds string value of that duration and use that in reporting

After export as Excel time fields are showing seconds but i want to see it in only Hours and Minutes

OR

3) try to see if you can use function field in report and convert the milliseconds to hours

OR

4) inform user to apply Formula in Excel and convert that, response from Jeff

How to display duration field value in a proper format in an excel report

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Mark Manders · ‎06-09-2025

You either create a custom field in ServiceNow to have the duration calculated to show just that (not recommended) or you update it in Excel. This is simply how ServiceNow stores duration fields.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

mhafizam · ‎06-09-2025

can you guide me in how to have the duration calculated.

Deepak Shaerma · ‎06-09-2025

Hi @mhafizam

In ServiceNow, the Duration field on the Incident table (or any other time duration field) is stored as a number in seconds (or sometimes in other units depending on configuration), but in the list view, it's often shown in a more human-readable format like "1 hour" or "25 minutes".

Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards
Deepak Sharma

mhafizam · ‎06-09-2025

Thanks for the explanation!

So just to check — is there a way to change the exported value to show in hours and minutes instead of seconds? Appreciate your help on this.