View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
computexcel computexcel is offline
external usenet poster
 
Posts: 43
Default Formula or else...

This I do it very often and wondering if excel can help me either with
formula, function, permutation...
I need to schedule X amount of employees to work 3 shifts a day ( 8 hrs )
in a week.
Q how many employees do I need ?
taking in consideration that no more than 40 hours a week per employees.

Also if I do it different, lets say, How many employees for:
2 shifts a day (12hrs), 7 days, 36 hours per employee.

I think combination or permutation is the key, but how do I start?
THANKS.