We use MYOB for payroll. We use an excel spreadsheet for the weekly roster. We would like the weekly roster to automatically calculate the total hours worked by each staff member instead of doing it manually. There are different rates for different times of the days, so as well as an overall total hours worked, the excel spreadsheet must also calculate totals for each different time period.
There are several different classes of employees. Each different class of employee has its own rate/times. Most employees hours change every week.
An excel spreadsheet has previously been created to do this but it is too complicated. We just need the totals, not all the workings. This file is attached. It has two sections. The section Staff Roster works well but it is the computation section that needs to be refined into a much simpler format.
16 freelancers are bidding on average $102 for this job
HI, I have lots of experience with data processing using excel. I can provide you with a easy to use solution for the computation sheet with just the click of a button. Please check PMB psprongs
Dear Sirs, Iam familar with creating excel formulation as a financial analyst at an Korean company. So that, I think I could do this work well. Please tell me more detail what you want do. Best Regards, Ha.
Hi I am an MBA from University of Canberra (Australia). Did MYOB course in accounting unit. I am also good at excel. You can count on me for this project. Thanks.
Hi there, I truly believe you need to review the over all cause to the need of such a tool! I'll write to you privately with a recommendation. Kind Regards, Loren