I have a spreadsheet that calculates the Difference between Time In and
Time out and takes this value to calculate the time you should clock
out so that you are 0 minutes over or under (+/-). There is a cell
that allows you to enter any time you were over under from the previous
month (in the event that you don't clock out on the time recommended by
the spreadsheet). The Cell that totals the sum of the differences in
time out - time in takes into consideration this manually inputted time
from the previous month.

The problem I am having is that when I enter a negative value (in
format -0:02) I get a popup error stating "the formula you typed
contains an error. If you are not typing a formula avoid typing an = or
a - or precede it with a '"

If I preceed the negative with a ' at the suggestion of the popup box,
the cell that calculates the sum of the differences + the previous
month's +/- (in this case -) ignores the negative value. If it's a
positive value, it works fine.

Any suggestions?


--
B. Baumgartner
------------------------------------------------------------------------
B. Baumgartner's Profile: http://www.excelforum.com/member.php...o&userid=23107
View this thread: http://www.excelforum.com/showthread...hreadid=383682