A VHCC Bi-Weekly Time Record for Hourly Employees is now available on the Z:\ drive in the Z:\DOCS folder.  The name of the spreadsheet is “Hourly Time Record”.  It is a “read-only” document; you may complete the spreadsheet and print it.  However, if you wish to save your changes, you must save the document to your computer.

Input is restricted to certain fields on the spreadsheet.  Below are instructions for each of the accessible fields.  Click on each numbered area to go to the appropriate instructions:

1. Name: Enter your last name, first name, middle initial.
   
   
2. Social Security Number: Enter only the last 4 digits of your social security number.
   
   
3. Week Ending Date: Entry of “M/D” will result in date being entered in proper MM/DD/YY format. Example: entry of “3/16” will result in “03/16/06”. The dates for each day of the week will then be automatically filled in.
   
   
4. Times “in” and “out” are recorded in this area. In this example, the employee worked a 20-hour week, a varied daily schedule. Remember that you cannot work more than 6 hours without taking a 30-minute break.  Total hours worked each day are automatically calculated in tenths of an hour.  Hours must be entered in 24-hour format. (Example: 4:30 p.m. is entered as “16” in the hours space and “30” in the minutes space – “16:30”) A conversion chart is provided in the same Excel workbook in which you find the Time Record Form.  Access the conversion chart by clicking the "24-Hour Format" tab (indicated by the red arrow in the example below). 
   
   
5. Employee's department
   
   
6. Supervisor’s department.
   

If you have any questions regarding the use of this form, please contact Dava Sweeney by e-mail at dsweeney@vhcc.edu or by phone at extension 2520.