Hi guys, thanks for the help on the previous question. I do have another though, I've created a simple rota sheet, start time and end time are entered for each staff member. I used the formula "end time" minus "start time" times by 24 to give me the amount of hours worked, each day is added up and the total for each staff member per week is shown, however if someone is on holiday I don't know how to input this without messing the formula, the #value! message is shown the total box? Any ideas how to get around this?
