rounding a calculation down to the nearest 0.5 - how?
 

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

rounding a calculation down to the nearest 0.5 - how?
 

=Floor(num_days,0.5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Suza" wrote in message
...
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

rounding a calculation down to the nearest 0.5 - how?
 

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
--
Kevin Backmann


"Suza" wrote:

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