software

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

=Floor(num_days,0.5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Suzaquot; gt; wrote in message
...
gt; need to calculate holidays based on no of weeks worked x entitlement =
gt; ROUNDED DOWN TO NEAREST 0.5 DAY
gt;
gt; Able to round down but can't understand the 1/2 day
The following function might work for you:=IF(MOD(A1,1)gt;=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 gt;= .5, it adds .5 to the integer value in A1, otherwise it
returns A1
--
Kevin Backmannquot;Suzaquot; wrote:

gt; need to calculate holidays based on no of weeks worked x entitlement =
gt; ROUNDED DOWN TO NEAREST 0.5 DAY
gt;
gt; Able to round down but can't understand the 1/2 day