How to organize a system of keeping records of the working time of employees?

Question

Time Management

There is a department with employees who every day fill out a table in an excel file with the name of the activity and the amount of time spent on this activity:
Name of activity | Number of hours
Searching books | 5
Completing documentation | 0.5
.............. | ............
Certain fields are summarized.
Each employee fills out his file and at the end of the month / week sends it by mail / net to the head of the department.
Required: calculate, display the amount of time for each activity for all employees of the department at once, who fill out each of their files.
What is the best way to do this?

Answer 1

Tin. What you are looking for is called task manager | task tracker | issue tracker.
Check out jira, redmine

Answer 2

That is, at the end of the month, it turns out there are 20 * number of employees of Excel files that need to be summarized?
We sort through all the files with the vba macro, stuff them into one plate, calculate the statistics from it, or simply build the correct summary.

Answer 3

"automation" at such a "level" kills any motivation of employees completely
decide what you need first of all: high performance or unnecessary "reports" in Excel filled out manually and without standards