The VHCC Bi-Weekly Time Record for Hourly Employees is 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. Instructions for each of the numbered sections are listed below the image:
- Name: Enter your last name, first name, middle initial.
- Employee Number or Social Security Number: Enter either your employee number or only the last 4 digits of your social security number.
- Week Ending Date: Entry of “M/D” will result in date being entered in proper
MM/DD/YY format. Example: entry of “10/30” will result in “10/30/08”. The dates for each day of the week will then be automatically filled in.
- 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).
- Employee's department
- Supervisor’s department.
If you have any questions regarding the use of this form, please contact Dava Sweeney by e-mail at firstname.lastname@example.org or by phone at extension 2520.