Then, write down the following code in the Module.Instantly, the Microsoft Visual Basic for Applications window opens.Alternatively, press ALT + F11 to do the same task.Then, select Visual Basic on the Code group.Firstly, make a new column Total Time under Column F.Furthermore, if you often need to do the task in a unique way, then you may consider the VBA code below. Although using formulas is a quick way of editing data, it can be difficult to interpret. It returns the remainder after a number is divided by a divisor.Īnother alternative is to employ the VBA code. Then, write down the following formula.At the very beginning, create a new column Total Time between columns Out Time and Lunch Time.In our very first method, we will perform subtraction using a simple formula. Using Arithmetic Operator to Subtract 30 Minutes from a Time in Excel Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.ġ. Now, we’ll calculate the Total Working Time of each employee using various approaches by subtracting the 30 minutes of Lunch Time from their residing time. Here, this dataset contains the Name of the employees along with their In Time, Out Time, and a fixed Lunch Time (in minutes) in columns B, C, D, and E respectively. 8 Ways to Subtract 30 Minutes from a Time in Excelįor better understanding, we’ll use an Employee Time Tracker of a certain organization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |