On Thu, 07 Jul 2005 21:30:00 -0400, StargateFan
wrote:

So, here is the problem again in a nutshell:

How to get the above #### to display the time correctly when there is
a negative number of hours to show, i.e., in this case -2h57m
yet keep 0h0m when I did work the full day.

If you want to display negative time in the Excel time format, you will need to
be using the 1904 date system. Select Tools/Options/Calculations Workbook
Options and SELECT the 1904 date system.

When you switch to the 1904 system, be aware that any dates in your workbook
will be shifted by four years.


--ron