Hi.
I am trying to devise a spreadsheet that shows four variables:
Employee
Employee Hours
weekending date
Project Name
The spreadsheet attached is what I have come up with; however it seems quite cumbersome as the employees will be working on different jobs throughout the week.
Ideally a pivot table would work, however, I need to load this spreadsheet into Google Drive for the boss to look through. The boss is not great on Excel, not too sure if he would work on pivot table, plus unsure if pivot table works in Drive. Originally, I had one sheet per job but we have 20 jobs on the go, so it is not realistic. I need the information consolidated into one spreadsheet. I am drawing a blank on a different way of approaching this.
Thanks for any advice/thoughts.
Bookmarks