trouble with subtracting cells and adding text...
 

To get the 39.61 hours your cell must be formatted as number with two decimal
places. When you use the & in the cell you see the full formatting. If you
format the cell with the 39.61 showing as having a lot more decimal places
you will see the same as with the &.
--
Gary''s Student


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