Duration field Reporting Format change

[umermunirtd]

I have a report in which I sum the duration field but my issue is that it displays the duration in days,hours,minutes format. I want it to display in hours,minutes format. Can I do that?

Regards,

Umer

[srinivasthelu]

Hi Umer,

I dont think it is possible.

You need to create a new calculation field on the table and add a script to calculate the value for this new field according to your need.

Thanks

Srinivas

[Jeffrey Siegel]

I know this is an old question, but you most certainly can do this now.  in the report, after you aggregate it, you can use the Set Value Formatting Button to set the maximum duration unit to Hour and minimum to second, this will eliminate days from being displayed, 1 day and 6 hours will read as 30 hours.

[Zaman Sm]

Thanks for sharing. It works.