Posted by David on October 15, 2001 3:13 AM
is there a formula where if you type a persons name you would get what they are making per hour times the number of hours worked in the total for the day. For example Stewart makes 10.00 per hour, Kathy 15.00, Steve 12.00 etc. If I had a roster that was done fortnightly can I get a calculation to find out the total per day by all persons entered for that day. The tricky part is that Saturdays the pay is +25%the hourly rate, Sunday +50%, holidays +150% and between the hours of 19:00-7:00 +15%.
Some people may only work two hours a day and others three etc. Any solutions? In a given day you may have up to five person working at different hourly rates.