Skip to Content
California State University, Long BeachCalifornia State University, Long Beach

Tip of the Month - March 2009

Calculating Excess/Minus

For employees required to track Excess/Minus, try these tips:

Download or print out the Absence and Additional Time Report.

At the beginning of each pay period enter the hours the employee is scheduled to work on the line labeled Alternate Work Schedule (AWS). Below is an example for the *February pay period, Jan. 30 – Feb. 28 (21 days or 168 hours) of a full time employee who is on a 4/10 Monday thru Thursday with Fridays off.

Timesheet showing employee hours in AWS line

Accessible version of the above timesheet example.

Note: the total for AWS is 160. This indicates that the employee must report Excess Minus (EM) of 8. This employee worked 4 hours on Friday, Feb. 20 (day off) which was reported as Compensatory Time Earned Premium (CTPR). Note: these 4 hours are not used to calculate Excess because it’s not part of the employee’s scheduled workdays.

*Pay periods will contain either 21 or 22 workdays. In a 21 day pay period, a full time employee must work 168 hours. In a 22 day pay period they must work 176 hours. Part time employees are calculated pro-rata. Please refer to the Payroll Calendar for the number of days in a pay period.

More information including the complete Excess Hours Business Process Guide.