Hi all! I am having difficulty using formulas to calculate the number of employees who are working each hour. I believe this is because my overnight shift is a little tricky. Below is the formula I am currently using and a snip of my scheduleSchedule photo.PNG Any ideas on how to get the overnight to calculate correctly, on the correct day would be greatly appreciated!
=(COUNTIF($C$6:$C$23,">="&A35)-COUNTIF($B$6:$B$23,">"&A35))
Thanks!
Bookmarks