Changing 17.56 to display time 17.34 1

[jleboeuf]

Hi,

Using CR 8.5

I have a number field in my database who stock time, i want to convert it to display regular time format (can be string or any format i don't have any calculation do to with it)

17.56 in database result i want in report 17.34

Thanks

Jean-Paul Leboeuf

jp.leboeuf@ggi-international.com

 

[lbass]

You can convert the number to an actual time, by using:

numbervar x := {table.numbertime};
numbervar hrs := truncate(x);
numbervar mins := round(remainder(x,truncate(x))*60);
time(hrs,mins,0)

Then you can format it to display however you wish.

-LB