How to Create a Timesheet

Save

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.

Tips & Warnings

  • 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.
Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Calculate Time Cards in Excel

    Microsoft Excel can be used to track work hours. Time-card templates are available on the Microsoft Office website. The templates contain formulas...

  • How to Create Your Own Spreadsheet Program

    Second to word processing, spreadsheets are one of the the most popular uses of computers. If you cannot find a program to...

  • How to Make a Time Card in Excel

    Excel's time and date functions make it a useful tool for office management purposes. One of the most basic functions is making...

  • How to Make an Employee Time In & Out Sheet

    The U.S. Department of Labor requires employers to maintain payroll records for nonexempt employees. This includes timekeeping records showing the time and...

  • Deltek Timesheet Tutorial

    Using Deltek's online employee self-service timesheet to record employees' work time reduces the time and expense of processing payroll for businesses. Deltek's...

  • How to Figure My Timesheet in Tenths

    Do you use a timesheet? A variety of consultants and professionals bill not just by the hour, but by the half hour,...

  • How to Make Timesheets With Google Docs

    Users of Google services may access Google Docs to create items such as spreadsheets, presentations, forms and timesheets. Look for the timesheet...

  • Creating a Time Sheet

    Create a time sheet by opening Microsoft Excel to create a formula that calculates information related to working hours and payment. Make...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!