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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Similar threads
- Solved
