=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 the “30” in to remove their break time.
Current forumlar is: =MOD(D8-C8,1)-TIME(0,30,0)
Any help would be great!
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 the “30” in to remove their break time. Current forumlar is: =MOD(D8-C8,1)-TIME(0,30,0) Any help would be great! Read More
