Using Excel but can't get hh:mm to go negative when subtracted

Trying to monitor hours worked vs hours planned eg planned 37 hours, worked
36 hours therefore want -1 hour ..... Help driving me mad

You won't get it.

You can get 1 by using

ABS(time_1-time_2)

and test if time_2 is greater than time_1 to prefix with a -, but this then
becomes text

=IF(time_2>time_1,"-","")&ABS(time_1-time_2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bobuk33" <[email protected]> wrote in message
news:[email protected]...
> Trying to monitor hours worked vs hours planned eg planned 37 hours,
worked
> 36 hours therefore want -1 hour ..... Help driving me mad