Need formula to calculate # of employees working each hour

Vdillon

New Member
Joined
May 12, 2019
Messages
1
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. Here is the formula I am currently using and a snip of how my schedule is built. 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!
https://ibb.co/Fg2WHfz
 
Last edited by a moderator:

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
You could put examples of the data you have and the expected result.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,987
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top