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

If you always have 2 decimal places, there should be no harm if you use the ROUND function.