Hello nolomcdc and Welcome to Excel Forum.
The way the hours are entered will make a difference. However lets say that cell C15 contains 7a-3p;3p-11p. We could use wildcard characters in the COUNTIF function as in: =COUNTIF(C4:C19,"*"&$A32&"*")
Note that 'on' has been removed from cells A32:A34.
I will have to look at part two later if no one else has solved by then.
Let us know if you have any questions.
Bookmarks