How to display data in HH:MM:SS format within the Display Data Table of a report.

[NDixon23]

Hello,

I am attempting to have the average business elapsed time in the display data table of a report output as hours:minutes:seconds rather than days:hours:minutes:seconds. Is there any way to achieve this in isolated situations like this without affecting the rest of the system?

I have seen in this post: https://community.servicenow.com/community?id=community_question&sys_id=03cfb2addb58dbc01dcaf3231f961942 that the hours in the axis can be altered by creating a new field and following the instructions of the post, but I don't believe this will deliver the desired result of changing the display data table of my report. Thank you very much for any suggestions or help that can be offered!

[Abish]

Hi NDixon23

The duration field would display this format only. There is no OOB way to changing the format. 

If needed you can create a new field populate this new field using script in required format and pull that field on the report. 

Please mark correct and helpful if my response helped.

Regards

Abish R

[NDixon23]

Thanks for your reply, Abish!

I did happen to create a field titled Business elapsed in hours, however when I pull that field in the report it returns no data. Do you see any discrepancies in my entry?

Or perhaps there is some sort of business rule which I need to enact first to trigger it?