Report - Hours Worked
This report shows the total hours worked, number of days present and the average hours per day for any month. This report can be generated for one month for all employees.
Details of columns are -
1. Official Hours - this field is calculated based on the setup done on Attendance
Setup page in "Official Hours / Days Worked Definition" table. If Shift Begin
and Shift End times are selected in setup as the basis for Official Hours then
total number of hours in the shift are taken, breaks are not excluded.
2. Shift Hours - If a particular day is counted as "Days Worked" as per Attendance
Setup then Shift hours for that day are also counted. For days when the
attendance status is a mix of two or more status the hours will be calculated
only if Multiple Status column is selected.
For example if a company has 9 am to 6 pm shift and an employee is on half day
leave and is present for half day and Multiple Status box is selected for "Days
Worked" then the Shift Hours will be equal to 9 hours. If the box is not selected
then Shift Hours will be zero.
3. Days Worked - this field is calculated based on the setup done on Attendance
Setup page in "Official Hours / Days Worked Definition" table
4. Avg Hrs/Day - formula is- Official Hours / Days Worked
In the detailed excel which you can get by clicking on "Export All Details" button
you will see the following additional details -
1. Official Hours for each day will be shown separately
2. Shortfall hours - total of shortfall hours will be shown, shortfall is calculated
as follows - If employee has worked less then his shift hours then it will count
as shortfall, "Shortfall = Actual Shift Hours - Actual Hours Worked", this column
will show sum of shortfall hours for all days in the range
3. Extra hours - total of extra hours if worked will be shown, extra hours are
calculated as follows - If employee has worked more then his shift hours then
the extra hours will be calculated, "Extra Hours = Actual Hours Worked
- Actual Shift Hours", this column will show sum of extra hrs for all days
Sample reports are available in article attachments.
Related Articles
Report - Groupwise Attendance
Menu : EazeHR > Reports > Attendance This report provides key attendance statistics by Department, Division, Office Location or Work Location on a monthly basis. You can see the average of hours worked by employees also the name of employee which has ...Report - Attendance Details
Menu : Reports > Attendance Detailed report which gives day wise attendance status of an employee for a given data range. Details of breaks taken and total hours worked are also available. It also shows the location from where the card has swiped if ...Report - Daily Attendance Record
Menu : EazeHR > Reports > Attendance This report is similar to Attendance Details report but with one critical difference, Out-time is always shown as Shift End-time, the actual Out-time even if recorded is not displayed. This report can be generated ...Report - Attendance Calendar
Menu : Reports > Attendance This report shows the attendance status for multiple employees across multiple days in a tabular form. This report can be generated for all the employees together but can be generated for maximum period of one month at a ...Report - Attendance Shift Details
Menu : Reports > Attendance This report shows day's status of attendance and provides metrics in comparison with the shift timings. This reports shows late coming, hours worked, hours worked within shift, early leaving, shortfall. Refer to the ...