I'm reporting on a database hosted on MSSQL 2008 R2 which uses a Time datatype to display a duration. If an event took 2 hours, 12 minutes and 30 seconds, the value is '02:12:30.0000000' If it took 1 minute 41 seconds the value is '00:01:41.0000000'

In my report, I'm using a formula containing Right(ToText(XXX),8) to strip off the fracitonal seconds, which we don't care about. This dispalys correctly in the Crystal Reports Builder, but Logicity dispays values less than 1 hour with a 12, so the value '00:01:41.0000000' is displayed as 12:01:41

Is there a way to correct this other than building a more elaborate formula that builds the text value with the time is less than 1 hour?