Excel allows us to get create a basic timesheet formula with breaks using the MOD function. 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
Generic Formula:
- To calculate work hours, taking into account break time that needs to be subtracted, you can use the below formula.
=MOD(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.
- 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.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- Finally, we will get the result in the selected cell.
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 **and Excel Formulas *!! **
Top comments (0)