C
Charlie
I am building a scheduling sheet that will change weekly.
The cells are set for time and I need to subtract start
time from end time to get number of hours worked. My
problem comes when an individual has a day off. These
days off vary week to week. If I put OFF in the start
time I get a #value error. I have a second sheet that
links to the first and transfers the hours worked to this
second sheet and then computes employee cost. How can I
have my standard formula in each cell so that it will
transfer to the second sheet, and still be able to put
text in without messing up my entire second sheet.
The cells are set for time and I need to subtract start
time from end time to get number of hours worked. My
problem comes when an individual has a day off. These
days off vary week to week. If I put OFF in the start
time I get a #value error. I have a second sheet that
links to the first and transfers the hours worked to this
second sheet and then computes employee cost. How can I
have my standard formula in each cell so that it will
transfer to the second sheet, and still be able to put
text in without messing up my entire second sheet.