Excel Forum
Similar Content
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 allows...
Excel Time - Summing Time Greater than 24 Hours
Tutorial: I'll show you the easy and simple way to sum time past 24 hours in Excel.  All we really h...



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.