program/formula to randomly allocate employees to available shifts

H

HarryLPA

If i have a database of employees' contracted hours and the days they're
available to work, as well as a list of the shifts i need to be filled every
week, is there a way of using a microsoft office program to randomly select
and allocate employees to those shifts based on their availability and
contracted hours?
 
Top