We are performing two calculations, one to figure out the total time the person was at work (D5-A5) and one to calculate how long the break was (C5-B5) and then we subtract the lunch break from the time at work (the larger time figure) to get the result. This time, there is a bit more work involved but it is all simple math. Since these examples are in military time (24 hour time format) it is quite easy to see how this works, starting with cell C2 in the formula, which is the largest number here. You want the time from which you subtract the other times to be the latest time in the day. Make sure to start right-to-left when you do this. Getting the total time worked for both is fairly straight-forward.įor the first example, we simply subtract the break time from the other time: There are two examples in the worksheet, one where you simply record the amount of time the worker was on break or at lunch, and one where the actual start and finish time of the break or lunch is recorded. (Dont forget to download the accompanying worksheet for this tutorial so you can follow along.)įormula to Calculate Time Worked Minus the Lunch Break This is actually quite simple once you know it, but too many people overcomplicate this. Ill show you how to use Excel to calculate the total time worked in a day minus lunch time or any breaks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |