What is the formula to find out average working hours from attendance consolidate report?

Created by Raghul David, Modified on Fri, 20 Jun at 1:49 PM by Product Content Team

An attendance consolidated report refers to a summary or compilation of attendance data from multiple sources or periods. It provides an overview of attendance records for a specific group of individuals or an entire organization, typically over a defined period of time.


As an admin, you can find out the average working hours by using the below formula:


Average Working Hours = Total Hours/[(Present+Leave+Absent)+(Decimal value of Total Hours)].


Looking for More Support?

Find answers and insights across our resources. Refer to our detailed Knowledge Base for in-depth articles, explore our practical video guides, and stay informed with our latest product updates.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article