Report time worked in hours and minutes

[Tad Davis1]

I am building reports to show total time worked on tasks.  I am pulling from the Time Worked [task_time_worked] table.  Filters set to only show tasks that were updated this week, task type is Incident (I have other reports for other task types).  My issue is anything over 24 hours shows as Days - Hours - Minutes.  I want it to only show in Hours and Minutes.  I've seen people saying go to the Dictionary Entry of Time Worked and add an attribute of max_unit=hours.  Others are marking it as solved but mine is not working and it doesn't do anything.  Since I need this to reflect in reporting, I have a feeling this new attribute will only reflect in list and form views and not in reporting.

[sachin_namjoshi · Accepted solution]

Adding attribute affects only the display on forms and lists. It does not change the display for reports. Consider reporting duration rather than task time worked to see hours and minutes in a report.

You can use OOB incident metric for finding our duration.

OR

better to use task_sla table to see total time worked on tasks if you have SLA configured on your instance.

Regards,

Sachin