VLookUp a value in a range of data in a Table
In MS Access, I had a table that enable me to round up chargeable time to the nearest quarter of an hour. The minimum charge was 1 hour and this incremented in 15 minute chunks of time.
MinutesFrom | MinutesTo | HoursToCharge
1 60 1
61 75 1.25
76 90 1.5
91 105 1.75
What is the best way to achieve the above in FM, is there a better way?