Duration Field value needs to display in days format in Reports

[Ashok32]

Hi All,

As per my requirment, I need to show the duration field value in the forma of Days Minutes Seconds format. While I am experting it to excel thart duration field value is showing in the form of seconds. And Same thing is repeated for the Reports also.

Could you please guide me to convert this seconds in the format of Days Minutes Seconds.

Thanks in advance. 

[Tony Chatfield1]

Hi, this requirement would normally be provided by a reporting 'function' field
Report on function fields (servicenow.com)

or you can add a custom field to the table and set content with a before BR (which I think is more\less what a function field does in a limited way).