Reporting data output changes - Seconds to Mins or Hours

[TomC]

Hello,

Is there a way for Hornbill to present data in other formats or an expression that can be used to change the data output format? 

For example, Resolve time currently comes out in seconds, whereas it would be more effective for my reports to be presented in Minutes or Hours, especially as I am trying to automate reports so I want to avoid having to manually manipulate the data from seconds into hours. 

I am currently using the reporting feature within Service Manager to produce my reports.

Any advice would be helpful, thanks. 

[Steve Giller]

MariaDB has a SEC_TO_TIME() function that may assist here.

[Jim]

@Steve Giller where are we able to use this feature in the reports?