Hiya all, I am relatively new to Access, but I do have a basic understanding.
I have been given a task at work to setup an automatted roster database with which the person enters the start and finish times for the employees (employee details etc ar in tables allready) and work out the costs by day and by week.
My problem is this:
Mon, Tue, Wed & Fri are normal rates of pay (NormCost) between the hours of 7am-6pm. From 5am-7am & 6pm-8pm it is 1.5*(ROP), any other times are at 2*(ROP).
Thu is the same except 6pm-9pm is still normal (ROP), 9pm-11pm are at 1.5*(ROP) & after 11pm is at 2*(ROP). They also recieve a penalty addition between 6pm-9pm (LNT)
Sat has a different rate again but penalty rates are the same as weekdays.
Sun are all at 2*(ROP).
I can't work out the formulas needed to work these calculations out.
For a normal (ROP) I have entered this:
(WedF-WedS)+(ThuF-ThuS)+(FriF-FriS)+(MonF-MonS)+(TueF-TueS)*24
But what if during these days they work outside of the normal hrs? This part I can't figure out how the expression would look.
I havn't done anything in the macro sections as yet as I don't fully understand how that part works.
Any suggestions would be grateful.
Cheers in advance if I can get this to work.
I have been given a task at work to setup an automatted roster database with which the person enters the start and finish times for the employees (employee details etc ar in tables allready) and work out the costs by day and by week.
My problem is this:
Mon, Tue, Wed & Fri are normal rates of pay (NormCost) between the hours of 7am-6pm. From 5am-7am & 6pm-8pm it is 1.5*(ROP), any other times are at 2*(ROP).
Thu is the same except 6pm-9pm is still normal (ROP), 9pm-11pm are at 1.5*(ROP) & after 11pm is at 2*(ROP). They also recieve a penalty addition between 6pm-9pm (LNT)
Sat has a different rate again but penalty rates are the same as weekdays.
Sun are all at 2*(ROP).
I can't work out the formulas needed to work these calculations out.
For a normal (ROP) I have entered this:
(WedF-WedS)+(ThuF-ThuS)+(FriF-FriS)+(MonF-MonS)+(TueF-TueS)*24
But what if during these days they work outside of the normal hrs? This part I can't figure out how the expression would look.
I havn't done anything in the macro sections as yet as I don't fully understand how that part works.
Any suggestions would be grateful.
Cheers in advance if I can get this to work.