Count if - only using time values

QuestionEdit

Hi -

I am usingfor Windows 2003. I use it to make my schedules. When an employee is scheduled to work, the cell contains their shift (e.g. 2-10pm) If they are not scheduled, it will say "off" or "vacation" or "FMLA", etc. I manually count how many people are scheduled to work that day.

What formula or IF statement might I use to havecount how many people are scheduled for the day?

AnswerEdit

It's not clear from the question how standardised the wording for shifts and not scheduled is - if there is some form of standard, then a countif would probably do it - seeing an example file might help me - if that is possible, my email is aidan.heritage@virgin.net