Spreadsheet Timecard


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?action=getinfo&userid=23107
View this thread: http://www.excelforum.com/showthread.php?threadid=383682

.

Relevant Pages

  • Re: Time Display Question Please
    ... I am not looking for a clock. ... an event in another cell of that spreadsheet. ... Can I get it to display a constantly updating time showing ...
    (microsoft.public.excel.misc)
  • Re: Excel 2007 high cpu usage, format cell, wrap text
    ... When she highlights the whole spreadsheet, and selects Format ... If the data cells are all contiguous, select any cell in the range and press ... This is necessary as Excel 2007 uses a lot of page memory. ...
    (microsoft.public.excel.misc)
  • Re: Print all columns - Excel 2007- How?
    ... Another thing you can do is to close up the cell widths which will allow the ... Press the print area icon and select set print area. ... the entire spreadsheet which includes columns A through I? ... Microsoft Excel MVP ...
    (microsoft.public.excel.newusers)
  • Re: .CVS to .XLS
    ... Your Spreadsheet recognises ... string only if it is stored in a cell of type string. ... if I have on the CSV file a field which is .1234. ...
    (comp.lang.cobol)
  • Re: Step Calculation
    ... If you would like to send me a copy of your Totals workbook, and perhaps 2 of the 13 individual workbooks, I will be happy to take a look and see if I can come up with a solution for you. ... I send out identical spreadsheet files to 13 team leaders for them to fill ... actually birds counted during the Christmas Bird Count, ... If there is a number in that cell, a count by that team for that bird, ...
    (microsoft.public.excel.worksheet.functions)