Excel can make calculating hours worked during lunch breaks a breeze! Use this formula: =AVERAGE(B2:B13)-B2B13, where B2 is your first break time and B13 is your last break time in minutes. This calculates the average of all work hours between these two times minus the total number of minutes spent on breaks. Say goodbye to manual