10 Replies Latest reply on Dec 15, 2012 11:41 AM by brian.curran

    VLookUp a value in a range of data in a Table

    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.