Hi!

In a custom SQL query, applied the formula to_char(round(((TIMESPENT/1000)/3600),'99.99'), the report display number .00 instead of 0.5 (30 minutes). The field is 1800000, then (1800000/1000)3600 = 0.5 in my calculator :)

I tried (TIMESPENT/1000)/3600 and round(((ct.TIMESPENT/1000)/3600)) and round(((ct.TIMESPENT/1000)/3600),2) with the same result (0).

I have Servidesk Plus Free Version 10.5 with PosgresSQL.

Thanks!!