How to calculate total work weeks?
Hi. I have several hundreds of employee clock in data(Name, Date, Hour, etc.). I only need to know how many weeks work per each employee. Is it possible to make formula in QB? Please teach me the...
Forum Discussion
I have a situation where I am reporting total projected work weeks scheduled. There is a start date and an end date where and a formula to calculate the total number of weeks scheduled.
I am having a problem reporting the information correctly because there can be (1) or more service technicians on site at a time. I would like to count how many service engineers are assigned to the job and multiply it by the total weeks, then I need to produce a report for how many work weeks are scheduled per month. Is this possible? I have a report now but can only calculate the total number of weeks scheduled per work order (it doesn't take into account how many service engineers were on site) and it only shows the total number of weeks in the ending month. It doesn't show the weeks per month accurately.
I am having a problem reporting the information correctly because there can be (1) or more service technicians on site at a time. I would like to count how many service engineers are assigned to the job and multiply it by the total weeks, then I need to produce a report for how many work weeks are scheduled per month. Is this possible? I have a report now but can only calculate the total number of weeks scheduled per work order (it doesn't take into account how many service engineers were on site) and it only shows the total number of weeks in the ending month. It doesn't show the weeks per month accurately.
