I have created a work schedule that calculates the amount of hours each person scheduled works (including 1/2 hour breaks on shifts over 7 hours) on that day. If someone is not schedule and I putt "off" in the cell I get the error #value! . How can I fix my formula to get rid of that error? The formula I am using is:
=MOD(C18-b18,1)*24-(MODC18-B18,1)>1/4)/2
Coumn B=time in
Column C= time out
Dolumn D- total shift hours
=MOD(C18-b18,1)*24-(MODC18-B18,1)>1/4)/2
Coumn B=time in
Column C= time out
Dolumn D- total shift hours