Would this work for you?
? cTimeformat(9.5)
? cTimeformat(6.75)
FUNCTION cTimeFormat(n)
return RIGHT("00" + ALLTRIM(str(INT(n))),2) + ":" + RIGHT("00" + ALLTRIM(str(INT(60 * (n- INT(n))))),2)
>hi all,
>
>i have 9.5 and i want 09:30
>i have 6.75 and i want 06:45
>
>how to resolve my problem ?
>
>Thank in advance for help
>
>bernhart
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.