Method to to create a timesheet in Excel

The process to create a timesheet might haunt you in the beginning as it requires you to be quite accurate as well as careful while making it. You must know some formulae, set it in the right place, and you are done. If you wish, you may also get its printout.

Only one time hard work is required and then you just need to sit back and stay relaxed. In case you wish to create another spreadsheet like this, all you need to do is copy paste the whole entries except for time.

The values you can input in it are as follows:

  • Date
  • Name
  • Job title
  • Entry time
  • Exit time
  • Lunch hours
  • Vacation hours
  • Leave hours

After naming all the categories, you need to do the required formatting such as filling in colors, resizing the columns and so on. Once it is done, you need to input the formula required for the timesheet creation.

Method to calculate the working hours of employees

For this, you must have the knowledge of formulas which need to be input after you have created columns of the categories given above. These might range from A to F and may vary from company to company.

  1. After creating the categories, select the desired range e.g. B2 to C2 or D2.
  2. To continue, press the Ctrl 1 button.
  3. This will open the ‘Format Cells’ settings.
  4. Next up, you have to select the ‘Number tab’ followed by ‘Category’ list box.
  5. Then, select the time and the time range from the ‘Type’ list.
  6. Click on the ‘OK’ button and repeat the same process for other columns.

To calculate the sum of hours, you may need to enter the formula i.e. =SUM(C2-B2)*the number of working days that could be any number.

This is how you can create a timesheet in Excel. Once it is created, you can take as many printouts of it as you want and circulate it to others as well so that they can have a glance at the areas of improvement.

Elia Smith is a Microsoft product expert and has been working in the technology industry since 2002. As a technical expert, she has written technical blogs, manuals, white papers, and reviews for many websites such as www.office.com/setup

Leave a Comment