number converted to time format

[cm1234]

I am running CR 9.0 and have a issue in getting a
number tabel converted to time format.
The string is made in MS sql and i need it to
be visual in CR as a time.
now it shows like 597 (a number)
and it schould be like 9:57(hh:mm)
Hope somebody can help me

best regards
cm1234

 

[acessn]

Are you quite sure you don't mean 957 that should be displayed as time(hh:mm)?

Could this work? Time then needs to be a string.

if length({your.time})=3 then 

left({your.time},1) & ":" & right(({your.time}),2)

else if length({your.time})=4 then 
left({your.time},2) & ":" & right(({your.time}),2)

\b

 

[cm1234]

Hi acessn

No im sorry it dont work, but thankyou for
your quick reply on this matter.
It is 597 minuts stored as number and that gives
9 hours and 57 min., i just need to get it
converted.

best regards
cm1234

 

[Madawc]

Try

ToText(Truncate(({mins}/60), 0)) & ":" & ToText(Remainder(({mins}/60)))

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[cm1234]

Hi

Sorry that it toke me so long to answar you, but in a
little org. you must put many different caps on.
Im sorry but it doesnt work.

best regards
cm1234

 

[lbass]

Instead of saying that something doesn't work, you should explain why. Try the following:

ToText(Truncate({mins}/60),0,"") + ":" + ToText(Remainder({mins},60),0,"")

-LB