Hello anyone that can help!!
I have tried searching all over the world for some help and decided maybe a post of my own will be the best route
I have been tasked in creating a pivot table to show employee hrs. I have the table created, however, I cannot get the OT hrs to calculate correctly using any of the formulas in former post. The tricky thing to our OT hrs is that if you do not work over 40 hrs in the week you do not get paid overtime, however I do want to show daily OT hrs in a separate column from the regular hrs by Job name.
Please take a look at the attached spreadsheet and let me know of any pointers you may have.
I REALLY appreciate it...my brain is SHOT!
Bookmarks