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.