Due to inclement weather, VHCC will be closed on Wednesday January 17
and on a Snow Schedule on Thursday, January 18, 2018.

Hourly Time Record

Press Enter to show all options, press Tab go to next option

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:

  1. Name: Enter your last name, first name, middle initial.

  2. Employee Number or Social Security Number: Enter either your employee number or 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 “10/30” will result in “10/30/08”. 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 or by phone at extension 2520.