2 Replies Latest reply on Jun 16, 2015 4:26 AM by marshdom

    Creating a Ranking Number from a record's Time

    marshdom

      Title

      Creating a Ranking Number from a record's Time

      Post

      Hi

      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?

      Many thanks