On Mar 9, 10:45*am, Nemo
<interpoculaLeSca...@LeScarpe.occupato.it.invalid> wrote:
> 125 hours divided by 8 = 15.625 days (ie 16 days) it
> would be better if the result was 15.5 days.
Perhaps "better"; but is it legal?
Setting the legal question aside, it appears that you want to round or
round down -- not clear which for lack of examples -- to the half-
day. What should 127 hours (15.875 days) become: 15.5 (round down),
or 16 (round)?
If A1 contains the number of hours (e.g. 125 or 127), then one of the
following computes the number of days:
=ROUND(A1/8*2,0)/2
=ROUNDDOWN(A1/8*2,0)/2
Note that I used "*2" for clarity. The formulas can be simplified
algebraically as follows:
=ROUND(A1/4,0)/2
=ROUNDDOWN(A1/4,0)/2
|
Similar Threads
