Ultimate Excel Challenge - Can You Solve This?

[Excelsiordude]

We are trying to set up a program based on Excell. We want to be able to enter the ARR/DEP Date, ARR/DEP Flight, ETA and ETD and have the two ETD HRC and ETA HRC and Arr Cost fields automatically fill in.

These will be based on the times manually entered in D6 and G6, with the ARR Method Code (eg A1, A2...). However, the code for the ARR Method will be different...

Each code will have different values show up in the ETD HRC and ETA HRC and Cost.

We have had 3 people work on this and we cant figure it out. Can anyone figure this bad boy out?



Thanks

 

[shg]

Welcome to the board.

Maybe they didn't know the alphabet soup. I certainly don't.

 

[Excelsiordude]

Sorry... here is the Excel image.

http://imageshack.us/photo/my-images/404/flightchart.jpg/