I am calcuating the difference in time between hours worked. In addition, I am subtracting one hour, to relect a lunch hour. My current formula is
=((MOD(J4-I4,1))*24-1
The problem is when an individual does not work for the day, the current formula is showing hours worked as -1 and is throwing off the total hours for the week.
Is there a conditional formula to include that would show a Zero if the referenced cells state "Off"?
schedule.jpg
Bookmarks