Simple Formula (I Hope) Assistance 1

[keeno]

Hello

I am using Crystal Reports XI on an Oracle database

I need to convert a Field (DURATION.TIME) from Minutes to Hours and Minutes.

Can someone advise what formula i need to apply to the DURATION.TIME field to show as HH:MM

Many Thanks

Keeno

 

[PatriciaObreja]

ToText(75 \ 60, 0, "") & ":" & ToText(Remainder(75, 60), 0, "")

will return: "1:15".
Replace 75 with your Duration field.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium