Hi,
I'm new to working with Dynamics 365 and new to the forum, hope I ask in the right place.
I have a table containing all the employees of the company, and another table containing the projects we are working on.
Each employee can work on several projects, and each project can have several employees.
Each employee writes in their own Excel table a date and how many hours they worked on each project. For example:
Date | 1001 | 1002 |
21/12/20 | 4 | 5 |
22/12/20 | 8 | 0 |
* 1001 and 1002 are projects, and the numbers below are working hours.
I want to upload the tables at the end of each month to the dynamics system.
What I want to happen:
1. All the hours that each employee worked will appear under his information so that it will be possible to know how many hours he worked on a particular day/month.
2. All working hours done for each project will appear under the project information.
This means that I can view a report with the total hours that employees worked on the project in a given period.
I would love a general explanation of how to approach this matter or even the guides who will help me understand the matter.
Thank you!