Subtracting time using [H]:mm function

[philbee]

Hi, I'm using the custom cell format [H]:mm to add times of tasks
entered by remote workers. I want to show a variance from the budgetted
hours which means the answer will sometimes be negative. The cell then
only shows *****. I can't find any way of calculating and displaying a
negative time answer such as -13:12, meaning 13 hours 12 minutes over
budget. Can you help? Thx

 

[Frank Kabel]

Hi
have a look at
http://j-walk.com/ss/excel/usertips/tip051.htm
for dealing with negative times