AnsweredAssumed Answered

VLookUp a value in a range of data in a Table

Question asked by brian.curran on Dec 14, 2012
Latest reply on Dec 15, 2012 by brian.curran

Title

VLookUp a value in a range of data in a Table

Post

     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
     Etc.

     What is the best way to achieve the above in FM, is there a better way?

     Thanks
     Brian.

Outcomes