In workplaces, the** timesheet **is a trendy term. It is a method that is used to record employee time records in the office. Originally, this method was developed to calculate salary at the end of each month considering overtime hours and break or lunch hours. **Microsoft Excel **has made our work easier to create a **timesheet**. In this article, we will create a** timesheet **in excel with 2 useful examples.

## Download Practice Workbook

Get this template to practice by yourself.

## 2 Useful Examples to Create a Timesheet in Excel

To describe the method of creating a timesheet, we will demonstrate here 2 useful examples for better understanding. Letâ€™s follow the procedure below.

### Example 1: Create a Timesheet in Excel for Individual Employee

In this example, we will make a timesheet of a single employee in a company. Also, we will calculate the payment at the end. Follow the steps carefully.

- First, insert the company name, page title, and other information (see image below) in
**rows 2**,**3**,**6**and**7**respectively.

- Then, create a table with the titles
**Day**,**Date**,**In Time**,**Out Time**,**Total Hours**and**Overtime Hours**. - Afterward, insert information to the respective titled cells like this:

- Following, go to the
**Home**tab and select**Fill Color**under the**Font**group.

- From here, customize your table with your preferred colors and the final output looks like this:

- Now, insert this formula in
**cell F10**.

`=E10-D10`

- Then, press
**Enter**. - Here, you will see the
**Total Hours**of the job done on**Monday**.

- Then, use the
**AutoFill**tool to get the result for the whole week.

- Next, insert this formula in
**cell G7**to calculate the**Standard Work Hour**using**the TIME function**.

`=TIME(8,0,0)`

- Now, insert this formula in
**cell G10**.

`=IF(F10>G7,(F10-$G$7),0)`

- Following, drag the bottom corner of
**cell G10**up to**cell G14**to calculate the**Overtime Hours**of each day.

Here, we applied **the IF function** to determine a logical comparison between **Total Hours** and **Standard Work Hour**.

- So far, we have successfully created a timesheet in excel for an individual employee.
- Along with it, let us calculate the
**Final Payment**based on work hours and hourly rate. - Initially, insert this formula in
**cell F17**to calculate the**Work Hours**of a week.

`=SUM(F10:F14)*24`

- Similarly, count total
**Overtime Hours**with this formula in**cell G17**.

`=SUM(G10:G14)*24`

Here, we used **the SUM function** to count the total hours in selected cells. Along with it, we multiplied it by **24** to get the result in** 24-hour **format.

- Next, insert this formula in
**cell F19**to calculate**Sub Total**based on**Rate/Hour**.

`=F17*F18`

- Similarly, count it for
**Overtime Hours**with this formula.

`=G17*G18`

- Lastly, apply this formula to find the
**Final Payment**in**cell F20**.

`=F19+G19`

- Finally, press
**Enter**and you will get your final output.

**Read More: How to Create an Employee Timesheet in Excel (with Easy Steps)**

### Example 2: Make an Excel Timesheet Template for All Employees

In this second one, we will create an excel timesheet for all employees in the department. We will also include the lunch hours this time. Letâ€™s see how it works.

- In the beginning, insert all the information in your worksheet as per the image below:

- Make sure to insert the
**Standard Work Hour**as described in the**1st example**. - Now, insert this formula in
**cell G10**.

`=(F10-E10)+(D10-C10)`

- Afterward, press
**Enter**. - Here, you will see the first input of the
**Total Hours**of**Joseph**.

- Lastly, use the
**Fill Handle**tool to get similar output for all the employees in**cell range G11:G16**.

- Thatâ€™s it, we have our timesheet template in excel.

**Read More: Excel Timesheet Formula with Lunch Break and Overtime**

## Things to Remember

- Make sure, all the hours in your dataset are in
**Time**format. Otherwise, it will show a false value. Also, keep it in**24-hour**format to avoid decimal values. - To calculate the final work hours of a whole week or month, keep the cell in
**Number**format. - If you are working in a
**12-hour**format, make sure to mention**AM**and**PM**. Because the**Out Time**is always greater than the**In Time**. So without the mention, it will show the wrong answer.

## Conclusion

Finally, we are concluding this article. Hope it was a helpful one for you on how to create a timesheet in excel with 2 useful examples. Let us know your suggestions on this. Follow **ExcelDemy** for more excel blogs.