primuspaul
Board Regular
- Joined
- Dec 23, 2015
- Messages
- 75
- Office Version
- 2021
- 2019
- Platform
- Windows
I am trying to keep track of time for a small number of workers working on various projects. Basically what I want is to have a "dashboard" that shows me in progress projects and how much time was spent on them so far with the potential for more advanced reports in the future. Data entry to it must also be available to each worker simultaneously, which does not appear to be possible with a single excel file. So what I did was I made a "time sheet" excel file for each worker to input project,start time,end time,statuschange and then I made a main projects file that power query appends each of those files' table to a single table. The table gets the latest (based on date) statuschange entry for each project and use a formula to put it into a calculated status field in that table, so the first few columns of the table are appended tables from those worker excel files and the ones to the right are calculated ones done directly in the table.
Then I run a pivot table on that table and slice the status so I only see non-completed projects.
Is that a good way to do it or is there a better solution? The reason I chose excel is I want something simple and don't want to deal with a complicated time management app online or have to work with a complex MySQL local server.
Then I run a pivot table on that table and slice the status so I only see non-completed projects.
Is that a good way to do it or is there a better solution? The reason I chose excel is I want something simple and don't want to deal with a complicated time management app online or have to work with a complex MySQL local server.