Hi all! First time poster here. I've built up a tool that my office is using, but want to build in a function to calculate how many hours over time that people have worked. I would like to have a form that will allow the user to pick a span of months (eg. Jan 2019 - May 2019) to see how many hours a given employee worked in that period of time. How should I structure this data? (There are currently 200 employees, and the number changes regularly).
I have a table called [Employees] that is currently structured with the following fields: [Employee Name], [Employee Email], [Hours worked Jan 2019], [Hours worked Feb 2019], etc. I realize that this is stupid, but I'm not sure how best to structure this data so that I can easily pull the numbers into a form. Ideally, the user would be able to select Jan 2019 - May 2019 and select the employee Bob Smith to see how many hours he worked, compared to the average hours that other employees worked.
Any guidance would be greatly appreciated. While I've done so much on this project already, I'm kind of confused at this point and I know that it would be a useful feature to have.
Thank you in advance!