Calculating total hrs, average per person, and then...amt above or below average used.
Posted by Bill on July 18, 2001 1:38 PM
I am not sure how to create an overtime tracking system with excel. I need to make a list of the employees, keep a running total of the number of overtime hrs each uses during a quarter, and be able at any day (or every day) produce a list or report showing the employees..the average ot used to date, and the relation + or - to the average each employee has so the hours can be given out fairly by the end of the quarter.
I have limited knowlege of how to make a pivot table but I am guessing that it would be the way to do it.
If anyone could help I would greatly appreciate it!