View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Changing Hours in working Days

Nemo explained on 3/9/2011 :
On Wed, 09 Mar 2011 15:06:11 -0500, GS wrote:
[...]

Well, I see some discrepancies here that need to be clarified before we
can effectively help you:

1. You state that the 'hours' can be paid OR taken as 'hourly'
leaves.
This precludes, then, that 'days' aren't a factor and so why are
you trying to calc 'days'?


Answer) In this thread,
we are taking into consideration only the extra overtime


This doesn't explain why you're calcing 'days'

, set in an account,using them as hourly leaves.


IOW, you're implementing a 'Banked Hours' system. This is typical
practice for businesses that pay employees by the hour on an 'as
needed' basis so that when work is plentiful (a.k.a.: 'in season') the
employees can work as much as they want but only get paid the normal
weekly hours so that when it's 'off season' they can 'draw' on their
banked hours. Often, the workers are laid off and so the banked hours
are used to supplement ui benefits. (legalities set aside!<g)

(The payed
overtimes follow another way)

2. You state that these hours are 'overtime'. Are they factored as
overtime (ie: time+1/2 OR double-time) OR are the overtime hours
converted to regular hours? Answer) Yes, they are overtime hours
converted into regular leave hours

3. You're dividing the number of hours by '8', suggesting that a
normal workday is 'actually' 8 hours + breaks/lunch. Is this the
case OR does this not matter?


Answer) The total daily working hours are '8' hours, it doen't matter if
thare are some breaks.


joeu2004's suggestions look good to me and so I won't be adding
anything here.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc