Hi,
The attached table has the hourly rate company A, B, and C use to calculate the amount of money
each company pay to the workers depend on the type of job (1, 2, or 3), date shift or night shift, and
how many hours the workers had worked. This is just an excerpt from a very big spreadsheet so I'm trying to
simplify it by trying to create a dialog box or something to give me the total pay for each company A, B, C when I put the work hour and select the type of shift, job.
example: if someone tell me he/she work 40 hrs, date shift, job 2, then I should have a dialog box to enter all that info and it spit out the total pay from Company A, Company B and company C.
Thank you very much,
VBisgreat
Bookmarks