How many sets of a number can I make?

[Hils713]

Hi! I have a huge set of data that includes hours employees have worked during a pay period. I need to know how many employees have worked 40 hours during the pay period. I can combine employees to get to one 40 hour employee. For example, if I have someone who has worked 40 hours they count as one. If they worked 50 hours they still count as one. If employees 3 and 4 worked 20 and 25 hours, respectively I can combine them to make 1 employee. How to I count the sets of 40 hours automatically in excel? An employee can only be used once and if the hours go over 40 then the overage doesn't go back in the bucket. Meaning employees 3 and 4 make 45 hours. The extra 5 hours can't go towards making another 40 hour group. Please help!

 

[GraH]

Hi, would it be possible for you to upload a sample of data using the xl2bb add-on?
Then we van provide and even test solutions we promise.