Allocating a staff based on the time they finish task keepin in mind start time of task.

I follow this forum regularly and I need help. To be frank I am not able to decide whether I have to take the Macro route (don’t know much about Macro’s though) or the normal formulas will work.

I have two columns. The first column(A) has date+time and defines when the work will begin. Column (B) has times when the work will end. I have staff whose numbers range from 1 to 14. I want to allocate the staff based on the work finish times. For example staff 1 finishes work at 23:57:00. So he can be allocated to a work which will begin at 00:02:00. The same happens for all staff between 1 to 14. Attached is a sample work sheet.

Basically trying to increase efficiency of staff utilization based on their job finish times in comparison with the job start times.

Thank you,

Azad.