Download Excel Start File https://people.highline.edu/mgirvin/Y...

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/