AnsweredAssumed Answered

Creating a Ranking Number from a record's Time

Question asked by marshdom on Jun 15, 2015
Latest reply on Jun 16, 2015 by marshdom


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?

Many thanks