Total, Average and Percentage of Time Lost per Employee by Starting Work Late

Total, Average and Percentage of Time Lost per Employee by Starting Work Late

This employee key performance indicator shows three measures:

1) total time the employee lost due to starting the work late

2) average time the employee lost due to starting the work late

3) ratio (percentage) of total time lost per employee against the total scheduled time per this employee

Time Lost because of Starting Work Late per employee is calculated as the difference between the actual Start time and Scheduled Start time. For example, if the Scheduled Start time on task is 9:00 AM and the employee was late and started to work on task at 9:30 AM, time lost is calculated as follows:

Time Lost = Actual Start Time – Scheduled Start Time = 9:30 AM – 9:00 AM = 0.5 hour or 30 minutes

Time Lost per employee as percentage is calculated by the following formula:

% Time Lost = (Time Lost per employee over time span / Total Scheduled Time per employee over time span) * 100

These measures can be used by the companies with strong discipline policies.

To calculate Total and Average Time Lost per Employee please follow the steps below:

• Create the custom field “Scheduled Start Time” with code “cf_scheduled_start_time”



 

You can enter Default scheduled Start Time to display it automatically for new tasks.

• Create the custom field “Actual Start Time” with code “cf_actual_start_time”



• Create the custom field “Time Lost” with the formula:

$cf_actual_start_time $cf_scheduled_start_time



• To view the total or average time lost per employee on Task List, filter your to-do list by the task group with tasks



• To view total or average time lost per employee over some period of time set the appropriate filters on Task List – Filters panel



• Set footer:
  • right click under column “Time Lost”
  • to see the total Time Lost per employee select “Sum”



• to see the average Time Lost per employee select “Average”



To calculate Percentage of Time Lost per Employee please do the following:

• Create a personal folder for each employee



• Create the custom field “Time Lost” with the code

 “cf_ time_lost” and the formula as described above



or if you would like to enter time lost manually, you can create the same custom field without the formula:



• Create the custom field “Scheduled Time” with the code

“cf_ scheduled_time”



Add total scheduled time per employee

• Create the custom field “% Time Lost” with the formula: ($cf_time_lost /$cf_scheduled_time)* 100



• On Task Tree select the root task group and select “Custom fields options”



• Set the following custom fields settings for the custom field: “Time Lost”
  • In “Settings for” select “Subgroups&tasks”
  • select “Enable”
  • in the field “Aggregated (for task group)” select “Sum” and the custom field name “Time Lost”



• Set the following custom fields settings for the custom field: “Scheduled Time”
  • In “Settings for” select “Subgroups&tasks”
  • select “Enable” and “Edit”



• To enter the value for the custom field “Scheduled Time” right click on task group and select “Edit”



• For the custom field “%Time Lost” set the following settings
  • In “Settings for” select “Subgroups&tasks”
  • select “Enable”
  • select “Calculated by custom field formula (for task group)”



• Right click on personal folder for which you need to display %Time Lost and select “Custom fields options”



• Set “Enable by parent” for the custom fields “Time Lost”, “Scheduled Time” and “%Time Lost”









%Time Lost per Employee on Task Tree