I have trying to do a rota time sheet in Excel. At the bottom of the sheet it
totals up the number of hours for each person, but when I calculate this
against a budget hours figure it won't give me a negative for short hours.
Can anyone help.

Excel can compute with negative times, but normally can't display
them. The work around is to use the 1904-based date system. Go
to the Tools menu, choose Options, then the Calculation tab.
There, check "1904 date system". Note, however, that this will
cause your existing dates to "shift" by 4 years, leading the
seemingly incorrect data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Martin" wrote in message
...
I have trying to do a rota time sheet in Excel. At the bottom of
the sheet it
totals up the number of hours for each person, but when I
calculate this
against a budget hours figure it won't give me a negative for
short hours.
Can anyone help.

Or you could hold the absolute value and have another cell signifying
whether it is negative or positive.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chip Pearson" wrote in message
...
Excel can compute with negative times, but normally can't display
them. The work around is to use the 1904-based date system. Go
to the Tools menu, choose Options, then the Calculation tab.
There, check "1904 date system". Note, however, that this will
cause your existing dates to "shift" by 4 years, leading the
seemingly incorrect data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Martin" wrote in message
...
I have trying to do a rota time sheet in Excel. At the bottom of
the sheet it
totals up the number of hours for each person, but when I
calculate this
against a budget hours figure it won't give me a negative for
short hours.
Can anyone help.