0 Replies Latest reply on Apr 1, 2014 10:36 AM by User26138

    Rounding up to the nearest half

    User26138

      Title

      Rounding up to the nearest half

      Post

           I have a database that calculates the number of hours holidays an employee is entitled to.

           This is done by a calculation that would result in a number that is unlikely to be a whole or half number.

           What I am trying to do is to get Filemaker to round up to the nearest half so if the calculated result is 6.4 it would round to 6.5 and 6.8 would round to 7.0

           If the calculated answer was 6.5 then it would stay at 6.5

           I have been playing with rounding and ceiling functions which I am sure hold my answer but have not had any joy.

           Any help would be really appreciated.