Time formula is correct in CR but shows 12:00:00 in CMC

[VE]

I've tried several ways to convert a number to a time, i.e. 165236 to 4:52 pm. I found some that work in CR without throwing an error but when I publish the report in CMC and run the report all the times show as 12:00:00 am.

I'm using CR 11 and CMC product 14.0.0

Thank you
VE

 

[SkipVought]

What is your conversation formula?

 

[VE]

I've tried several that I found, most of them gave errors in crystal, this one is kind of ugly but it works in crystal:

Time(
if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 1 then "00:00:00"
else
if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 3 then "00:0" + left(replace(totext({OVERLOG1.OVTIME}), ",",""), 1)+":00"
else
if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 4 then "00:" + left(replace(totext({OVERLOG1.OVTIME}), ",",""), 2)+":00"
else
if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 5 then "0" + left(replace(totext({OVERLOG1.OVTIME}), ",",""), 1) + ":"
+ mid(replace(totext({OVERLOG1.OVTIME}), ",",""),2,2)+ ":00"
else

if len(replace(totext({OVERLOG1.OVTIME}), ",","")) = 6 then left(replace(totext({OVERLOG1.OVTIME}), ",",""), 2) + ":"
+ mid(replace(totext({OVERLOG1.OVTIME}), ",",""),3,2)+ ":00"
else totext(time(00,00,00))
)