View Single Post
  #3   Report Post  
Roger Govier
 
Posts: n/a
Default

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