=MOD but show cell as blank if no data

Question

Hi all,&nbsp;Looking for help with an =MOD&nbsp;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 the "30" in to remove their break time.&nbsp;Current forumlar is:&nbsp;=MOD(D8-C8,1)-TIME(0,30,0)&nbsp;Any help would be great!&nbsp;&nbsp;

hansvogelaar · Answer

DanR115&nbsp;
=IF(OR(C8:D8="OFF"), "", MOD(D8-C8,1)-TIME(0,30,0))
&nbsp;
or
&nbsp;
=IF(OR(C8:D8="OFF"), 0, MOD(D8-C8,1)-TIME(0,30,0))

sergeibaklan · Answer

DanR115&nbsp;
As variant
=IFERROR( MOD(D8-C8,1)-1/48, 0)

danr115 · Answer

Thank you!

danr115 · Answer

Thank you!

Forum Discussion

=MOD but show cell as blank if no data

Share

Resources