You can change the references based on your need.Ģ. Note: In the above formula: C2 is the lunch start time, B2 is the log in time, E2 indicates the log out time and D2is the lunch end time. Enter this formula: =SUM((C2-B2)+(E2-D2))*24 into a blank cell beside your time record cells, F2, for instance, see screenshot: The following formulas can help you to calculate worked time a day based on the time records.ġ.
To finish this job, I can introduce some formulas for you.Ĭalculate hours worked and minus lunch time with formulas For example, I have the following daily attendance record which contains log in, log out and lunch start, lunch end times in a worksheet, now, I want to calculate the total hours worked but minus lunch time each day. How to calculate hours worked and minus lunch time in Excel?Īs a company employee, we need punch in and punch out every work day, counting the total worked time and minus the lunch time of a day can help to calculate salary according to the time.
