David,

I will try this and see what happens, thanks for the info. I will let you
know if it works.

Rhonda

"David Biddulph" wrote:

To get a negative time difference to display, you can use:
Tools/ Options/ Calculation, and select the 1904 date system, but there may
still be problems with your formula if you're using the & symbol rather than
+.

10/1/06 will be 38727 in the 1900 date system (or 37265 in the 1904 system),
and 4:45 PM is 0.697917. If you concatenate them, for example with the &
symbol, you'll get 387270.697917 (or 376250.697917), putting the zero which
was before the decimal point of the time at the end of the integer for the
date. Hence a one day change in the date will appear as a 10 day change in
the total. If you have the results formatted as [h]:mm to be able to see
the full number of hours, you'll see a 240 hour change, not 24 hours. You
must, therefore, replace your & symbols by +.
--
David Biddulph

"Rhonda" wrote in message
...
Otto,

The problem is not the size of the cell. This is what is in the cell:

Cell H11 - 10/01/06
Cell I11 - 4:45 PM
Cell F11 - 10/01/06
Cell G11 - 4:50 PM

So the formula is =(H11&I11)-(F11&G11)

The ###### appears in the column rather than a -.05 for the five minutes
difference, does this explanation help?

I thank you in advance for your prompt response.

Rhonda

"Otto Moehrbach" wrote:

Rhonda
To add to Pete's response, #### usually means that the cell has a
number
that is too large to fit into the cell. That is, the column is not wide
enough to hold that number. Increase the width of the cell as needed.
HTH
Otto

"Rhonda" wrote in message
...
I can't seem to get a negative result to display proper, see scenario
below:

Cell AL11 is the final calculation of (H11 & I11) - (F11 & G11).
Notice
the
### marks in AL11 due to the negative results. I need to keep the
existing
formula, but somehow display the negative results.

HELP - Rhonda!