K
keysol100
Hi,
How would I go about writing a User Defined Function that would allow
me to calculate night shift premiums for the following?
I have a list made up of 3 groups of employees:
GroupA, GroupB and GroupC.
Employees in GroupA and GroupB work a variety of shifts:
Days 6 hours,
Days 8 hours,
Days 12 hours,
Evenings 8 hours,
Nights 8 hours,
Nights 12 hours
Group C always works Days 8 hours.
Night shift premiums are paid only to groupA and GroupB as follows:
GroupA – Days 12 hours .90 cents for the shift
Nights 12 hours - $6.45 for the shift
GroupB- Nights 12 hours – $6.49 for the shift
Nights 8 hours - $4.28 for the shift
GroupC – no premiums are paid
Any help much appreciated
Gerr
How would I go about writing a User Defined Function that would allow
me to calculate night shift premiums for the following?
I have a list made up of 3 groups of employees:
GroupA, GroupB and GroupC.
Employees in GroupA and GroupB work a variety of shifts:
Days 6 hours,
Days 8 hours,
Days 12 hours,
Evenings 8 hours,
Nights 8 hours,
Nights 12 hours
Group C always works Days 8 hours.
Night shift premiums are paid only to groupA and GroupB as follows:
GroupA – Days 12 hours .90 cents for the shift
Nights 12 hours - $6.45 for the shift
GroupB- Nights 12 hours – $6.49 for the shift
Nights 8 hours - $4.28 for the shift
GroupC – no premiums are paid
Any help much appreciated
Gerr