Overtimes tracking | Process

Sheet #1 – Overtime Entries

This sheet is used by Project Managers (PMs) to record overtime hours worked by developers. Below are the details of each field and how to fill them out:

Fields Description

1. Developer (Column A) – Enter the name of the developer who worked overtime.
   Important – type developer’s name the same way as it is in Hurma, so the pivot-table sums up their worked hours correctly.

2. Date (Column B) – Enter the date when the overtime work was done in the format DD.MM.YYYY.

3. Number of Hours (Column C) – Enter the total number of overtime hours worked on that day.

4. Project (Column D) – Enter the name of the project for which the overtime work was done.

5. PM (Column E) – Enter the name of the Project Manager responsible for the project.

6. Month (Column G) – This field automatically extracts the month from the formatted date, no need to fill anything.

7. Compensated in Hurma? – This field is for the HR to mark compensated hours.

Sheet #2 – Summary

This sheet provides a monthly summary of overtime hours per developer. It will be used by HR to review and extract the totals for each month and compensate it in Hurma.

Usage Instructions

For Project Managers (PMs):

1. Open the “Overtime Entries” sheet.

2. Fill in the details for each overtime entry in the appropriate fields.

3. Ensure the date is in the correct format (DD.MM.YYYY).

For HR:

1. Open the “Summary” sheet.

2. Review the totals for each developer and month.

3. Use the summarised data to process overtime payments or for record-keeping.

4. Put checkmarks in the Overtime Entries sheet after the hours are compensated.