I've begun to use a spreadsheet so i can manage my fleet better.
I'm trying to come up with a Calculator that allows me to see the furthest airport I can fly an aircraft to, given the block time left on it.
But I have managed to mess up the formula and now I am unbelievably confused..and I have a headache.
What am I doing wrong in this formula?
Longest Possible Route (Distance) = ((Remaining Block Time - Turn Time - Turn Time) * Speed)
According to this formula a particular a/c in my fleet had enough time left to fly to an airport just 47nm away.. yet when I tried to launch the route, this a/c wasn't available

So what is wrong with my formula above? Help please coz it's driving me crazy!