Rounding up to the nearest half
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.