Hoe do I convert decimals to hh:mm in both main report & sub report???

[Toni1]

Hi, I am using crystal 8.5, I need to convert decimals 8.5 to hh:mm 8:30 in my main report and then in the summary in my sub report.
I have used the following formula and it works in the main but not in the sub. any help would be apprecciated

replace(totext (int ({ta_emp_pay_entitlements.pay_amount})+ (remainder ({ta_emp_pay_entitlements.pay_amount},1)*60/100)),'.',':')

thanks in advance

 

[vidru]

Check this thread: thread767-712606.

-dave

 

[synapsevampire]

Can you provide an example of where it doesn't work in the subreport? Rather than saying something doesn't work, try qualifying/quantifying.

You may have some problems with rounding, otherwise the formula looks OK.

An alternative might be to convert evyrything to seconds and then use part of the formulas in my FAQ:

faq767-3543

-k