Happy Greetings from wherever you are,
I have a pivot table that calculates regular and overtime hours worked by each employee on a weekly basis. I would like to know if there is a way of obtaining the Total Pay either by using an Excel pivot table calculated fields or an Excel VBA code to first multiply regular hours by $1.00 and overtime hours by $1.50 and finally adding the regular and overtime pay in a column next to the pivot table. Right now I can accomplish this task by calculating the total pay by multiplying regular hours (REG) by $1.00 dollar and the OT by $1.50 dollar and then summing up Regular Pay and Overtime Pay. The issue that I have with this approach is that as the pivot table adds more data or rows, I have to constantly drag down the formulas in columns G, H and I. I appreciate your shared knowledge and time to help me and others.
See attachment for better explanations.
Bookmarks