This may be in wrong area so mod may move if necessary.
What I am trying to do
1. Have created a seperate time sheet for each field employee. On time sheet I have day worked, Job#, Job Name, expenses Hours worked. What I would like to do is for my results page to look at each employee time sheet. If job number is the same I want it to combine all hours and be able to post in results.
Couple of example
Time sheet( Joe dirt)employee name
Monday 2731(job #) Billy bar $30 (expenses) 8 Hrs worked
8/25/14
Time sheet( employee)
Wednesday 2731 Billy bar $0 expense 8 hrs worked
8/27/14
in the results I would like returned
Job # Job Name Employees worked Total expense Total Hrs Wages Expenses Benefits
2731 Billy Bar Joe dirt $30.00(or what ever it is) 16 $ $ $
Employee
Next job number(all other job # and data as described above
I also need to be able to have different wage rates and expense and benefit rates( be able to change when required. Can have on time sheet of each employee.
I have been trying to figure this out for a while. I can do some complex math functions. If someone can assist I would appreciate it.
Bookmarks