Hi
I think you will need to use
=TEXT((Q12-A1),"0.00")&" HRS"
Regards
Roger Govier
traybuddy wrote:
A1=4278.39
Q12=4318.00
MY FORMULA IS...
=(Q12-A1)&"HRS"
IAM GETTING ...
39.6099999999997HRS
WHEN I SHOULD GET...
39.61HRS
IT ONLY HAPPENS WHEN I PUT THE... &"HRS" AT THE END OF THE FORMULA...
|