Excel Forum
Similar Content
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY
Tutorial: Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allow...



Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch


We have In Time & Out Time for either Day or Night Shift and we must subtract 1 hour for weekday lunch and 1/2 hour for weekend lunch. See the formula to make this calculation that uses the IF, MOD and WEEKDAY functions. In case the In Time and Out Time are blank or have the word "OFF", we will use the ISNUMBER and SUMPRODUCT to show a zero.
Download file: http://people.highline.edu/mgirvin/





Got a Question? Ask it Here in the Forum.