How to Create a Timesheetby Cellina LaForey
Creating a time sheet with Microsoft Excel is simple to do. The beauty is that you can modify or beautify the time sheet as you see fit. By adding a few columns and a time calculating formula you can keep accurate track of your working hours.
Click ”New” under the “File” menu to create a new Excel worksheet.
Navigate to cell A1 (that’s the first cell in the first column) and entitle the time sheet “Weekly Time Sheet For Week Ending: (Insert week here).” Once you create your time sheet you can always come back and change the name later.
Label the columns. In the next row, (row 2),insert the label “Date” in the first column, “Days” in the second column, the next column “Number of Hours,” the third column Hourly “Rate” and the final column labeled "Total."
List the dates and days of the week in the first and second columns. For instructional purposes, assume your company offers work shifts seven days a week. So, starting with Sunday, list the days of the week in column B starting on row 3 and ending with row 10. Widen the columns as needed. After checking a calendar go back to insert the corresponding date in the “Date” column (column A).
Place a formula in the “Total” column to automatically update the total earnings for the week. Starting with cell e3 insert the following formula: “+c3*d3”.
Duplicate the “Total” formula for each day of the week on the time sheet. Now that you have the formula for the first day of the week, all you have to do is copy it for the rest of the week. The easiest way to duplicate the formula is to select cell d3, right mouse click and select “Copy.” This invokes a marquis type of animation around the cell. Now take your mouse, drag it over the next few cells in the “Total” column to highlight them. With the cells highlighted, right mouse click and select “Paste” to copy the formula into the highlighted cells. Hit the “Esc” key to stop the marquis animation.
Test the worksheet. Insert some hours in the "Number of Hours" column and place your hourly rate in the “Hourly Rate” column. Check to see how the "Total" column automatically calculates your time.
- check Play around with the time sheet appearance. Select “Cells” from the “Format” menu option to see a variety of formatting options. Play around with the alignment, borders and fonts to create a time sheet that suits your needs.