View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DebC DebC is offline
external usenet poster
 
Posts: 39
Default time tracking formula (trying again)

http://www.savefile.com/files/1788734

sorry it has taken me so long to reply. I greatly appreciate your help!
Here is the link. In this workbook (I have set up for dates 1st thru 3rd,
but the actual workbook will contain 1st thru 31st, and for each month of
each year) I need to know how to determine or set whether it starts on or
off, and to have the next day begin where the previous day left off, whether
on or off. I also need a "Y", or "N" in column 'g'. I think that is as
simple as an 'If' formula. One other note here....this is a very small part
of my actual workbook; there are many more aspects, and I wondered, if I need
to move this, or add columns or rows is it a problem? As I said previously,
I don't understand the formula you provided, so I don't know how to adapt it.
I hope I have given you all the details you need. Please let me know if
not. Thank you again.



"Herbert Seidenberg" wrote:

Upload your file to
http://freefilehosting.net/
or
http://www.savefile.com
and I will add formulas and instructions.