Excel Formulas: Basic Timesheet Formula with Breaks ~ (Quick Formula)!!
Tags: excelformula, excelformulas
Published: 2021-05-01 08:26:34

---
title: Excel Formulas: Basic Timesheet Formula with Breaks ~ (Quick Formula)!!
published: true
date: 2021-04-30 14:07:26 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-basic-timesheet-formula-with-breaks/
---

Excel allows us to get create a **basic timesheet formula with breaks** using the [**MOD function**](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/). This step-by-step tutorial will assist all levels of Excel users in creating a basic timesheet formula with breaks. 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)

[![Basic timesheet formula with breaks](https://geekexcel.com/wp-content/uploads/2021/04/Basic-timesheet-formula-with-breaks.png)](https://geekexcel.com/excel-formulas-basic-timesheet-formula-with-breaks/basic-timesheet-formula-with-breaks/#main)<figcaption id="caption-attachment-34907">Basic timesheet formula with breaks</figcaption>

## Generic Formula:

- To calculate work hours, taking into account break time that needs to be subtracted, you can use the below formula.

**=[MOD](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/)(workend-workstart,1)-MOD(breakstart-breakend,1)**

## Syntax Explanations:

- **MOD** – This function returns the remainder of the two numbers after division. Read more on the [**MOD function**](https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/).
- **Work end** – It specifies the ending range of work hours.
- **Work start** – This value specifies the starting range of working hours.
- **Break start** – It represents the break time starting.
- **Break end** –  This is the ending range of break time.
- **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.

## Example:

Let’s consider the below example image.

- First, we will enter the input values such as work timing and break times in **Column B** to **Column E**.
- Now we are going to find the total work hours based on these input values.

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

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

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

- Finally, we will get the result in the selected cell.

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

## Wrap-Up:

From this short article, you can get to know how to create a **basic timesheet formula with breaks in Excel**. I hope you like this article!! If you have any **doubts,** feel free to let me know. I reply to queries frequently. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Extract Text Before First Comma or Space in Excel Office 365!!](https://geekexcel.com/extract-text-before-first-comma-or-space-in-excel-office-365/)**
- **[Excel Formulas to Assign Points Based on Late Time ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-assign-points-based-on-late-time/)**
- **[Excel Formulas to Add Days Exclude Certain Days of Week!!](https://geekexcel.com/excel-formulas-to-add-days-exclude-certain-days-of-week/)**