Anoka-Ramsey Community College

Initial Instructions for Time Sheet Spreadsheet

Open time sheet in MS Excel
Save the spreadsheet in your “G” drive.
In the “bargaining unit” box enter your union’s bargaining unit number. (214, 216, etc.)
Re-save your time sheet with these changes on it.

Pay period entry

Open the time sheet in your “G” drive.
Enter your work and leave hours in the top portion of the time sheet. Note: there are 26 tabs in this workbook (on the bottom), one for each pay period. Be sure to save your time sheet after each pay period entry to ensure your leave balances carry over to the next pay periods time sheet.
Print your time sheet (and leave slip if appropriate).
Sign your time sheet and obtain the signature of your Supervisor on both the time sheet and leave slip.
Submit to Payroll by the Monday following payday by noon.
If you need to amend a time sheet, please re-type it on your time sheet and type “AMENDED” in the remarks box, do not print it out and hand write it. Have your supervisor initial the change, if these procedures are not followed, the amended time sheet will not be entered and will be sent back to you for completion.

The following information must be entered on any leave slip form that is submitted.

Employee – First Name, MI, Last Name
Leave Code – Enter the appropriate leave code. If FMLA related, be sure to mark the FMLA related box.
From Date & Time – Enter the start date and time.
To Date & Time – Enter the end date and time.
Total Hours – Enter the total number of hours.
Date Requested – Enter the date the form is filled out.
Employee Signature – Type in your signature here when submitting the form.
* Block – Any comments can be made in this block (i.e. Reason for Overtime)