Time Calculation to showing negative value?

[Teabag]

I am attempting to create a a spreadsheet to calculate
Budgeted Hours - Actual Hours to show the remaining hours
on jobs.
I have formatted the cells as [hh]:mm and I'm using the
formula =SUM(A1-B1)this works correctly though problems
occur when B1 is greated than A1 as the result shows
##############
Is there any way to make this calculation so that the
result will show the time as a negative value?
Thanks in advance.

Teabag

 

[Frank Kabel]

Hi
have a look at
http://j-walk.com/ss/excel/usertips/tip051.htm

 

[Guest]

Thanks for that it now works!
Teabag

-----Original Message-----
Hi
have a look at
http://j-walk.com/ss/excel/usertips/tip051.htm

--
Regards
Frank Kabel
Frankfurt, Germany

I am attempting to create a a spreadsheet to calculate
Budgeted Hours - Actual Hours to show the remaining hours
on jobs.
I have formatted the cells as [hh]:mm and I'm using the
formula =SUM(A1-B1)this works correctly though problems
occur when B1 is greated than A1 as the result shows
##############
Is there any way to make this calculation so that the
result will show the time as a negative value?
Thanks in advance.

Teabag

.