Forum Discussion
=MOD but show cell as blank if no data
Hi all, Looking for help with an =MOD I am using it for rostering staff. If I have a staff member off, I want the cell to remain either blank or with a 0 for their hours on that day. I have t...
=IF(OR(C8:D8="OFF"), "", MOD(D8-C8,1)-TIME(0,30,0))
or
=IF(OR(C8:D8="OFF"), 0, MOD(D8-C8,1)-TIME(0,30,0))
Thank you!