Car assign simulation
 

Hi all,

I have a question as follows:
A B C D E
----------------------------------------------------------
Services Required Time Staff Car
Start Finish Provide
----------------------------------------------------------
1 T 1:20 1:35 12 ?
2 W 8:00 8:20 1 ?
3 W 8:10 8:30 2 ?
4 T 8:15 8:30 14 ?
5 W 8:20 8:40 3 ?
6 T 8:25 8:40 15 ?
7 T 8:35 8:50 16 ?

IF there are(sheet2):
CarW1 for W Services
CarW2 for W Services
CarT1 for T Services
CarT2 for T Services

How can I use a formula to assign the right car to the Coloum "Car Provide",
with no overlapping in time?

Thanks in advance.

Best Rgds,
L. Chung

Car assign simulation
 

see posting in worksheet functions

"L. Chung" wrote:

Hi all,

I have a question as follows:
A B C D E
----------------------------------------------------------
Services Required Time Staff Car
Start Finish Provide
----------------------------------------------------------
1 T 1:20 1:35 12 ?
2 W 8:00 8:20 1 ?
3 W 8:10 8:30 2 ?
4 T 8:15 8:30 14 ?
5 W 8:20 8:40 3 ?
6 T 8:25 8:40 15 ?
7 T 8:35 8:50 16 ?

IF there are(sheet2):
CarW1 for W Services
CarW2 for W Services
CarT1 for T Services
CarT2 for T Services

How can I use a formula to assign the right car to the Coloum "Car Provide",
with no overlapping in time?

Thanks in advance.

Best Rgds,
L. Chung