Creating a travel formula

Hello Guys

I am looking for help. I want to create an airport time formula. What i want to achieve we have clients who book airport transfers and constantly calling the office asking what time should they book they car for. So i wanted to create something that they could enter their flight departure time and depending on what airport, you would get a value which would be the estimated set off time. For example: Flying from Manchester airport at 16:00, you know you need to be there 2 hours before which is 14:00, you are then travelling from london, which you know is about 4 hour drive, so the system would say your setoff time would be appoximately 10am.

Many Thanks[/LIST]

Very simply

=Departure_Time - Check_in_Time - Estimated_Travel time

e.g. 16:00 - 02:00 - 04:00

Data required:

List of Airports

Check-In times (National vs Inernational)
.
Estimated travel times between destinations : for large town/ cities you could use existing mileage charts available and use estimated average speed.


Put together a "prototype" workbook and then come back if more help is required.

Tried it, just get #Value

Format all cells including result, as hh:mm

in D1 =A1-B1-C1

A1=Dept time
B1=Check in
C1=journey time

Thank you, it doesn't feel, like what im trying to achieve is possible. On the journey time, wanted to make it very simple, for instance, if journey time was 1 hour you would enter a 1 or 60mins and it would be calculated. As trying to figure out the journey time at present is difficult and returns a value of #############