Instructions for completing Classified Service Attendance Record in Microsoft Excel

• Open the Classified Service Attendance Record document.
• Click or tab to Name field, enter name.
• Click or tab to Pay Period field, enter the beginning and ending dates for the current pay period.  For pay period dates, visit www.buffalostate.edu/hr/payroll.asp.
• Click or tab to Department field, enter department.
• Click or tab to Building & Room No. field, enter your work location.
• Click or tab to Line No. field, enter line number.

Attendance Section

• Click or tab to Date field, enter actual calendar date worked. 

• Click or tab to Time In/Time Out fields, enter actual time in and time out in hours and minutes.

Total Hours Section

• Click or tab to Hours fields, (REG., O.T., O.T. Meals, Holiday Pay Hrs.). Enter actual time worked. The time entered should be entered in full hours worked. Minutes should be entered in ¼ hour increments. For 15 minutes worked enter .25 hrs. For 30 minutes worked enter .50 hrs. For 45 minutes worked enter .75 hrs. (1hr 15 minutes would be entered 1.25 hrs. etc.)

Accruals/Leave Time Used Section

• Click or tab to the Time Used fields (Vacation, Personal, Sick, Family Sick, Personal Leave, Comp Time, Over 40 Comp Time, Holiday Leave), enter time accruals charged. Minutes charged should be entered in the ¼ hour increment format described above.
• Click or tab to Remarks, Reason for O.T. column. Enter any remarks applicable to the corresponding day worked.

Accrual Total Section

• Click or tab to Balance Previous Period Brought Forward row, enter your accrual balances at the end of the last pay period (use your last timesheet).
• Click or tab to Accruals This Period row, enter your accruals earned this period on this row.
• For the Over 40 Comp Time column, enter the number of overtime hours worked  multiplied by 1.5.
• The Vacation Bonus row should be left blank. The Payroll Office will fill in this row when applicable.
• The accumulated accrual's field will calculate automatically.
• The Less Time Used - Shown Above row will calculate for you.
• The Balance End of Period row will total for you.
• Print the document.

• Employee must sign and date timesheet.

• The employee's supervisor must sign and date timesheet.
• Forward completed timesheet to the Payroll Office, CLEV 408.