Subtracting Time

[Bob Oso]

Hello,

I am subtracting sums of time and in some instances come across a negative
number which is displayed with #################. What is a good formula to
where if value is a negative number to display "-0" instead of "#"? For
example:
31:26 - 49:43. Currently excel dispalys #s...would like to display "-0".
Thanks.

 

[Tom Willett]

You are in the wrong newsgroup. This one is for FrontPage. Try one for
Excel.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
---------------------------
: Hello,
:
: I am subtracting sums of time and in some instances come across a negative
: number which is displayed with #################. What is a good formula
to
: where if value is a negative number to display "-0" instead of "#"? For
: example:
: 31:26 - 49:43. Currently excel dispalys #s...would like to display "-0".
: Thanks.