Conversion of seconds to minute in report for Resolve Time field

[qster]

Trying to create a simple "Average Resolve Time" report for an assignment group that's grouped by a category.

When we add the Resolve Time field, it's in seconds.

I'm looking for a way to calculate or format by minutes or even hours but I can't find a way to do that in a Report. 

[Tushar Hirpurk1]

Can you just shared what you are doing in filtration?

Actually what you need to do is if you want to convert seconds into hours you need to create new field

Just share the screenshot what you are doing in report

Regards,

Tushar

[Slawek_Radziewi]

You can use performance analytics where you will be able to do calculations or create a new field in table and calculate there before using in report.

[qster · Accepted solution]

We ended up building a metric for this.  However, I think Performance Analytics would work too, or possibly a database view with calculation for this field.  The metric was the quickest and most consistent solution for our use case.