Skip, thanks for the input. This is what I need to do.
When an employee takes time off we use the leave code 186. When they take a holiday, we use 188. There are numerous other job codes which are not an issue at this time. I can export the information that I need into an Excel spreadsheet such as:
Branch EmployeeID Name Date Job Hours
1 1234 bob 06-01-03 186 6.0
1 1234 bob 06-02-03 36078624 3.0
1 1234 bob 06-02-03 38123456 4.0
1 1234 bob 06-03-03 188 6.0
2 1472 steve 06-01-03 36078624 4.0
2 1472 steve 06-01-03 52122747 3.0
2 1472 steve 06-02-03 36078624 6.0
2 1472 steve 06-03-03 188 6.0
There are three branches and literally thousands of entries like those above in a month. What I have been doing is separating the branches (with help from people like you) and then creating a separate Pivot Table for each of the branches. It gives me the total hours for each individual employee’s work day as well as row and column totals for all. Bob would have seven hours on 06-02-03 and Steve would have seven hours on 06-01-03. All other days for both would be six hours (that includes Steve on 06-02-03). Leave and holiday are always six hours. Their row totals would be 19.0 for both.
If I cannot do any type of math or formatting on the PT itself (previous thread of mine), I was wanting to format the hours for the leave and holiday before the PT is created and transfer the formatted hours over to the PT. If they are bold, they will stand out. Currently, once I create the PT, I no longer can tell what the jobs and hours are for. Then once I get the bolded numbers over, I would count the number of bolded fields for each employee and include this on the report with the total days.
The other thought I had, which is much more complicated, was to read the job number and if it is 186 or 188 place an “L” or “H”, respectively, next to the hours on the PT. But then, I really can’t do any math b/c I now have a field such as “6.0H”.
Any thoughts will be greatly appreciated. TIA. Bill