I have been trying to find a solution to calculate this example scenario:
I am trying to create a work order estimate worksheet where a user can use this to calculate how much the work will cost based on which employee or employees are performing the job, how many hours it will take to perform the job, and on the cost per hour of each employee.
For example:
I have 3 employees: employee 1, employee 2 and employee 3 in Column a. I would like the user to be able to use a combo box to select multiple employees.
Each employee has a different cost per hour:
Employee 1: $10
Employee 2: $20
Employee 3: $25
In this example, I would like to calculate a job that will require 2 hours to perform by each individual. So, the total hours will be 4 hrs.
However, how do I calculate the total cost if I were using a combo box, and a user is selecting 2 employees, and each one of them has a different cost per hour?
Any feedback is welcomed.
I am trying to create a work order estimate worksheet where a user can use this to calculate how much the work will cost based on which employee or employees are performing the job, how many hours it will take to perform the job, and on the cost per hour of each employee.
For example:
I have 3 employees: employee 1, employee 2 and employee 3 in Column a. I would like the user to be able to use a combo box to select multiple employees.
Each employee has a different cost per hour:
Employee 1: $10
Employee 2: $20
Employee 3: $25
In this example, I would like to calculate a job that will require 2 hours to perform by each individual. So, the total hours will be 4 hrs.
However, how do I calculate the total cost if I were using a combo box, and a user is selecting 2 employees, and each one of them has a different cost per hour?
Any feedback is welcomed.
