Conerting a String Field to Hours/Minutes

[keeno]

Hello

I have a string field (DURATION) which currently shows number values like 48.0 etc which i need to convert to display Hours and Minutes (Something like 48:00)

I am running Crystal Reports XI against an Oracle 10G Database

Your help would be greatly appreciated

Kind Regards

David

 

[lbass]

Please see faq767-3543.

-LB