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