# Calculate number of employees working each hour.

1. ## Calculate number of employees working each hour.

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!

2. ## Re: Calculate number of employees working each hour.

Hi and welcome to the forum

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

3. ## Re: Calculate number of employees working each hour.

hi! Here is the workbook. :0

4. ## Re: Calculate number of employees working each hour.

See if the following will work for you:
Formula:
`Please Login or Register  to view this content.`

I have marked the schedules that showed differences between the formula and manual count (6:00 AM - 10:00 AM).
Let us know if you have any questions.

5. ## Re: Calculate number of employees working each hour.

Thanks JeteMc, this was a huge help!

There are currently 1 users browsing this thread. (0 members and 1 guests)