AnsweredAssumed Answered

Trouble with a calculation

Question asked by claddam on Apr 23, 2009
Latest reply on Apr 23, 2009 by davidhead

Title

Trouble with a calculation

Post

Hi there.

 

I am having trouble with a calculation.

 

I have a drop down box that has 4 Places, pretend it is AAA, BBB, CCC and DDD

 

I also have a box entered for a specific time, say when a flight is to leave. All times entered are in 24 hour time, eg: 0800, 1200, 1350, 1800

 

 

My goal is to make a calculation that tells people what time they need to leave to get to one of these places (AAA, BBB, etc.) before their flight leaves, so I assume the calculation would be:

 

Time = 

 

If Place = "AAA" ( FlightTime - 400; "-" ) or If Place = "BBB" ( FlightTime - 200; "-" ) and so on.   <- The "-" represents a nil time if it can't find anything in the "Place" field.

 

Yet it doesn't seem to be working.

 

Any ideas? 

Outcomes