How to create a timesheet in Excel?

Are you a business owner and it has become difficult for you to keep a record of entry and exit time of your employees? Well, it is quite a difficult task for a human being to calculate their working hours, overtime, and so on. 

But, if you have a good command on Excel, then this task of yours can become relatively easier. Most of the Excel users might not know about this feature and if you are also one of them, then this article can be a really helpful one for you. 

With this feature, you can easily follow the timeline of your office mates and the resulting graph will let you know their progress and patterns of productive hours as well.

So what is an Excel timesheet?

In simple terms, we can say that it is a kind of document that contains different records of employees’ work time. The timesheet is not only helpful for businesses, but can prove to be helpful in educational institutes as well. 

It can help to track the entry and exit time of teachers or students which could be a difficult task for a manager to manage. 

Read Also >> Learn to use Word dictate feature on Mac

In earlier times, all of this was done on a register which is known as a ledger and in classical times this was enough for tracking the time of workers. However, the times have completely changed now. The employers needed something that is more accurate and easier. Hence, if you are able to use this feature successfully, then you can manage the data of employees at your fingertips. 

In addition to this, it has also made the payroll work easier. So, let us now learn the basics of creating a timesheet. 

Method to create a timesheet

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.

Disclaimer: is an independent and on-demand Microsoft Office related service provider. We disclaim any association with Microsoft or its subsidiaries. The brand names, facts, logos, and images of Microsoft used here are just for referential purposes and these belong to its propriety i.e. Microsoft. Do not take us to be Microsoft because we in no way are related to it. Go through our terms and conditions and privacy policy before taking any action on this website. In case, you come across third-party links or references, make sure to go through their policies separately.