I'm trying to work out the calculations necessary to pull information held about users who have multiple pay levels into a timesheet.
For example: Sam gets paid at £9.62 per hour for Project A, and £8.58 per hour for Project B. This information is already held in a user app as pay rates, with a calculation to work out the hourly rate based on the annual salary for each rate. However, other users earn differing amounts for the same project - ie. Joe earns £11.17 for Project A. This means I can't set a pay rate for each project; it has to be linked to the user.
I have an app which totals the monthly amount of hours based on individual entries - Sam does not work every day, so will need to input individual entries eg. 5th Oct 4 hours Project A, 6th Oct 3 hours Project B, 9th Oct 5 hours Project A, 10th Oct 4 hours Project B. Currently my app will calculate the total for the month as Sam's timesheet entries are linked to the monthly one.
What I need in the individual entry is for it to show their name (pulled from the monthly), then they can select date, hours and project.
The monthly one then needs to calculate the user's rate for a given project: If user = Sam and if Project = A then Hourly rate = [calculated field] and a calculation under each rate to show total hours * hourly rate.
Can anyone help?
Please sign in to leave a comment.