I have a sheet where I am trying to calculate hours worked against hours
allowed.

I am able to add the hours worked in a period but when I try to subtract the
hours worked from the hours allowed I get an error if the hours worked are
lower than what is allowed.

This is what it looks like:

hours worked 42:26:00 29:31:00
hours allowed 41:00:00 38:00:00
Over Budget 1:26:00 ########################


The formula for over budget is as follows:
=IF(D29<0,(D29-D30)," ")

Does anyone know how to make this work show it shows me the correct
information?

Thanks in advance.
Ed Davis