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 think that the closest I can come is for you to make a Summary report which has an <ask the user> filter on employee and summarizes the time records with a Group by "week". The bottom of the report will have the number of "groups" (weeks). But I know that does not gigve you a clean employee list for all employees with a clean column with your answer.