Multiply the subtraction by 24 (the number of hours in a day... time values
are decimals that are a fraction of a full day). For example...

=24*(A1-B1)

--
Rick (MVP - Excel)


"Steve" wrote in message ...
Hi Rick

thanks for the quick response.

I tried it, but it gave the result -0.1666667 - so we're sort-of
there, but I want the result to show -4,so to show I worked 4 hours
less than I was contracted to.

Any more ideas?

Steve



On Tue, 24 Mar 2009 14:57:51 -0400, "Rick Rothstein"
wrote:

After you put the formula in the cell, change the Cell's format to General
and you should see the negative values you want.