Excel Formulas to Create a Timesheet for Overtime Calculation Formula!!
Tags: excelformula, excelformulas
Published: 2021-05-29 07:44:50

---
title: Excel Formulas to Create a Timesheet for Overtime Calculation Formula!!
published: true
date: 2021-05-28 16:35:27 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-create-a-timesheet-for-overtime-calculation-formula/
---

For instance, there is a table recording a worker’s work on and work off time, and you want to calculate the overtime hour and the payment as below screenshot shown, how can you quickly solve this task in Excel? In this chapter, we will discuss the formulas to **create a timesheet for overtime calculation in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Timesheet for overtime calculation](https://geekexcel.com/wp-content/uploads/2021/05/Timesheet-for-overtime-calculation.png)](https://geekexcel.com/excel-formulas-to-create-a-timesheet-for-overtime-calculation-formula/timesheet-for-overtime-calculation/#main)<figcaption id="caption-attachment-45755">Timesheet for overtime calculation</figcaption>

## Generic Formula:

- You can use the below formula to calculate overtime and pay associated with overtime in Excel.

**=(reg\_hrs\*rate)+(ot\_hrs\*rate\*1.5)**

## Syntax Explanations:

- **Reg \_hrs** – It represents the input regular time from your worksheet.
- **Ot\_ hrs** – It specifies the overtimes.
- **Rate** – It represents the input rates.
- **Multiplication**  **(\*)** – In this symbol will multiply any two values or numbers.
- **Plus operator (+)** – This symbol is used to add the values.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B** to **Column F**.
- Here, we have to calculate the overtime.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-57.png)<figcaption id="caption-attachment-45757">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-97.png)<figcaption id="caption-attachment-45756">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-91.png)<figcaption id="caption-attachment-45754">Result</figcaption>

## Bottom-Line:

In this tutorial, we have described the simple tricks to **create a timesheet for overtime calculation in Excel**. I hope you like it. Mention your **queries** in the **comment** box below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[How to Copy a Cell to Clipboard using Macros (VBA) in Excel 365?](https://geekexcel.com/how-to-copy-a-cell-to-clipboard-using-macros-vba-in-excel-365/)**
- **[Excel Formulas to List Holidays between Two Dates ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-list-holidays-between-two-dates/)**
- **[Excel Formulas to Sum the Time by Week and Project ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-sum-the-time-by-week-and-project/)**
- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**