Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) |