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_2time_1,"-","")&ABS(time_1-time_2)

--

HTH

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


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