Here is how I have it set up:
In one table I have names of employees for a one week schedule. Next every name I have columns for 7 days. In each column I have 2 cells for start shift and end shift. Those cells use another table where I have a listing of times from 12:00am till midnight with 15 min incroments. At the top of that table I also have a blank for a day off and a "vacation".
When an employee of mine is trying to make a schedule they select the start and end shift. There is a column at the end of the week where I'm trying to have all the hours added up for each employee.
This is where I get stuck. If let say the select an 6 hour shift, it shows total hours for the week correctly but if I select "Vacation", it displays ##### (=Value).
How do I get the vacation cell to display "Vacation" and also have a value of "0" hours for my total hours scheduled column? I have tryed to link the cell next to it with a value of 0 but in "IF" I don't think I put the formula properly.....
PS.
To be honest with everyone I don't know anything about Excel and this is the first time I'm working with the formulas. I wish I could attach my file for everyone to have a better understanding of what I'm trying to accomplish.....PLease help me out
<!-- / message -->
In one table I have names of employees for a one week schedule. Next every name I have columns for 7 days. In each column I have 2 cells for start shift and end shift. Those cells use another table where I have a listing of times from 12:00am till midnight with 15 min incroments. At the top of that table I also have a blank for a day off and a "vacation".
When an employee of mine is trying to make a schedule they select the start and end shift. There is a column at the end of the week where I'm trying to have all the hours added up for each employee.
This is where I get stuck. If let say the select an 6 hour shift, it shows total hours for the week correctly but if I select "Vacation", it displays ##### (=Value).
How do I get the vacation cell to display "Vacation" and also have a value of "0" hours for my total hours scheduled column? I have tryed to link the cell next to it with a value of 0 but in "IF" I don't think I put the formula properly.....
PS.
To be honest with everyone I don't know anything about Excel and this is the first time I'm working with the formulas. I wish I could attach my file for everyone to have a better understanding of what I'm trying to accomplish.....PLease help me out
<!-- / message -->
