Creating a Ranking Number from a record's Time
This sounded simple when I first looked at it but my inexperience began to show straight away!
I have a couple of hundred records of airline flights which contain a Time field (hh;mm), the duration of the flight.
I need each record to contain an auto-entered Ranking number field for these records based on the length of the flight.
eg: All flights over 10 hours get ranking 1 - flights over 9 hours but less than 10 get ranking 2, over 8 but under 9 get 3.. etc.
After getting really messed up with a calculation field containing multiple nested IF functions I realised I was on the wrong track!
Can anyone point me in the right direction?