Then you'll have to switch the workbook to the 1904 date system
(Tools/Options/Calculation). Be forewarned that if you already have dates on
the worksheet, they will change by 1462 days (4 years + 1 day). If that's a
problem, post back and we'll tell you how to fix it.

On Thu, 17 Mar 2005 14:25:06 -0800, "Thomas99"
wrote:

I am trying to create a spreadsheet to track employee time records, and I
need a way to enter "negative" time numbers.

In order to correct data entry errors, I need the ability to enter "-8:30",
for example, and include that figure when totaling the column.