Excel's string of #s is trying to tell you that you have a negative time,
which Excel does not support.

You may be able to work around this with something like:
="-"&text(abs(yourcaclulation),"h:mm")

Regards,
Fred.

"Connie Martin" wrote in message
...
So, I have to put in an extra column to convert my numbers to Excel time?
I've tried that and then used those columns to calculate by but I'm
getting
##################### as the answer. Connie

"Niek Otten" wrote:

Excel stores times as fractions of a day.
So to get minutes, divide by the number of minutes in a day:

=A1/24/60
will give you A1 as Excel minutes. Of course
=A1/1440
will do as well.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Connie Martin" wrote in message
...
Believe me, I've searched Help, but I'm not finding my answer. In A2 I
have
a time, formatted as time, which is 8:30 AM. In B7 I have a time,
formatted
as time, which is 8:00 AM. G7 is formatted h:mm, and I have my formula
there, which is =SUM($A$2-B7), which is working properly. It gives me
0:30.
Now's the problem. In C7 I have 30 (meaning 30 minutes). In D7, I
have
120
(meaning 120 minutes). I don't know how to format C7 and D7 to
minutes.
I
want to also extend the formula in G7 to not only calculate the
difference
in
time between A2 and B7, but to add the minutes in C7 and subtract the
minutes
in D7. The formula in G7 should give -0:60.

Can anyone help? Connie