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

B

bobuk33

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

Bob Phillips

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)
 
Top