Hours worked formula

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

=if(j4="Off",0,((MOD(J4-I4,1))*24-1)

That worked. THANK YOU!

No problem, glad I could help.

If you feel the thread has answered your question, please choose Thread options at the top and mark the thread as solved so others can reference your query.