rounding a calculation down to the nearest 0.5 - how?

[Guest]

need to calculate holidays based on no of weeks worked x entitlement =
ROUNDED DOWN TO NEAREST 0.5 DAY

Able to round down but can't understand the 1/2 day

 

[Bob Phillips]

=Floor(num_days,0.5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

The following function might work for you:


=IF(MOD(A1,1)>=0.5,INT(A1)+0.5,A1)

The MOD function divides the value in a1 by 1 and returns the remainder, if
the remainder is >= .5, it adds .5 to the integer value in A1, otherwise it
returns A1