Monthly Time Sheets

The monthly time sheet can be used with Microsoft Excel or Adobe Acrobat to make recording work hours easy for the employee and the department's leave representative. The time sheet calculates total hours, leave used and extra time accrued and provides daily, weekly and monthly totals after start time, end time and leave used for the day are entered.

Download the time sheet for use with Microsoft Excel.

  • Field descriptions and directions can be viewed by mousing over fields containing a red triangle in the upper right corner.
  • Enter information into blank fields only. Fields where you cannot enter information are autofilled by the time sheet.
  • An Error! message in the Total Hrs columns may indicate: 
    • a space is needed between the time and AM or PM  
    • a null value has been accidentally entered; select the field, right-click and choose Clear Contents .

Dates

Select the month using the drop-down arrows in the Month field in the upper right of the time sheet. Enter the year in the formula bar or by editing the Year field.  Date and Day fields will autofill.

Time

Enter the time you began work in the In field, add a space, and enter AM or PM. Enter the time you stopped work in the Out field, add a space, and enter AM or PM.

See example on the top line of the spreadsheet: The example indicates the employee started work at 8 a.m., left at 10 a.m., returned at 12:30 p.m. and ended the work day at 2:30 p.m., resulting in a total of four hours worked for the day.

Leave

Record vacation or sick leave by entering the number of hours in the designated column. Enter other types of leave in the "Other Leave" columns by entering the number of hours in the left column and the leave code in the adjacent right column. Leave code abbreviations can be viewed by mousing over the red triangle in the Leave Codes field.

See example on the top line of the spreadsheet: The example indicates the employee used one hour of vacation leave, one hour of sick leave and two hours of family leave.

Acrobat Time Sheet

Download the time sheet for use with Adobe Acrobat.

  • This interactive form requires Adobe Acrobat. Purchase Adobe Acrobat for office use through Site License
  • Enter information into blank fields only. Fields where you cannot enter information are autofilled by the time sheet.
  • The "Value entered does not match the format of the field" error message may indicate: 
      • a space is needed between the time and AM or PM  
      • the time is not in hour and minute format (i.e., 8:00 or 12:30)

Dates

Select the month using the drop-down arrows in the Month field in the upper right of the time sheet. Edit the Year field if necessary. Click any field to autofill Date and Day fields.

Time

Times must be entered in an hour and minute format (i.e., 8:00 or 12:30). Enter the time you began work in the In field, add a space and enter AM or PM. Enter the time you stopped work in the Out field, add a space and enter AM or PM.

See example on the top line of the spreadsheet: The example indicates the employee started work at 8 a.m., left at 10 a.m., returned at 12:30 p.m. and ended the work day at 2:30 p.m., resulting in a total of four hours worked for the day.

Leave

Record vacation or sick leave by entering the number of hours in the designated column. Enter other types of leave in the "Other Leave" columns by entering the number of hours in the left column and the leave code in the adjacent right column. 

See example at the top of the time sheet: The example indicates the employee used one hour of vacation leave, one hour of sick leave and two hours of family leave.