Date printed: 01-18-2019   Last updated: 07-20-2016

To view our complete support knowledge base and most current version of this article visit

Applies to versions: 2.3, 2.4, 2.5, 3.0

Worked Months Report - Avg Weekly Hours

The Worked Months - Avg. Weekly Hours Special Report shows the average weekly hours that each employee has worked during each month of the year. This report works just like the Worked Months report but shows a weekly average that can be helpful for ACA reporting.

NOTE: You can also view a subtotal of time worked by employee for a specified date range by running a Time Report for a group of employees. See the Time Edit/Reports section.




Using the left pane Main Menu » Administration, click on: Reports » Special Reports

Special Reports provide information and data from the system beyond the standard Time Edit/Report. Select a report by clicking on the report name.






Under Miscellaneous, click on: Worked Months - Avg. Weekly Hours




Worked Months - Avg. Weekly Hours Report


NOTE: Time Worked is rounded to the nearest 10th of an hour.

On months that are complete (or not yet complete), the Average hours are based on the days in the month.  For example, working 100 hours on a month with 31 days will be a "weekly average" of 100 hours/31 days * 7 days_in_a_week = 22.58 weekly avg hours. This will be shown on the report rounded to 22.6  Working 100 hours in a month with 28 days would be 25 weekly avg hours.

For years that are incomplete, only the completed time is figured into the average. For example, if an employee has worked 100 hours in the entire year, and it's noon on May 14th, the average will be 100 hours/133.5 days * 7 days_in_a_week = 5.3H per week avg for the year so far.

©2004-2019 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.