Forum Discussion
What formula to use here
Hello there, I need help figuring out which formula to use here... Every day employees send me their hours for that day, which project they were working on, and for how long. At the end of the we...
DylanTowbes I'd recommend using PowerQuery to clean up that data first. Then you can easily create pivot tables. One for the hours per employee to check the payroll and another to summarise all hours by project for billing.
Example attached!
- Thanks so much for this, I'll give it a shot!
