The problem is that Excel won't display negative time unless you use the
1904 date system. The 1904 date system can cause other problems so I would
recommend not using it.

What you can do is use a decimal format instead.

=IF(D29<0,(D29-D30)*24,"")

Format as GENERAL

Biff

"Ed Davis" wrote in message
...
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