COUNTIF
Can anyone let me know the best way to handle thin on?
Sheet 1
In column A I have a list of employees, in column B I have a list of their
start times and in column C I have a list of their finish times.
What I am wanting to do is caculate how many employees are at work during
specific hours. ie 09:00 to 12:00 of 10:00 to 15:00.
I was trying to use some sort of COUNTIF statement but could not get
anything to work which got me thinking is the is a totally different way to
do this.
Thanks
|