# Re: Changing Hours in working Days

joeu2004
Guest
Posts: n/a

 9th Mar 2011
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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?TF9uX2Rh?= Microsoft Excel Worksheet Functions 2 29th May 2005 06:16 PM Alex Microsoft Excel Programming 1 14th Sep 2004 06:39 PM Alex Microsoft Excel Misc 1 14th Sep 2004 06:29 PM Alex Microsoft Excel Worksheet Functions 1 14th Sep 2004 06:00 PM Chinny Microsoft Excel Misc 3 19th Apr 2004 06:24 PM

Features