Use:
=text(Q12-A1,"0.00")&" HRS"


Mangesh






"Cricketer" wrote in message
...
I agree with Roger except I think you need a /100 in the calculation.
Even if you put in 0.00000000% you still retain the integrity of the
calculation.
I tried several options including Concatenate and all but this method lose
the accuracy of the calculation. Anyone know why?
--
Cricketer


"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...