Forum Discussion
JDEMARIE
Dec 30, 2018Copper Contributor
How to return a 0 in a blank cell-formula
Hello all, I have a formula below where I am returning the number of hours (i.e. 12) depending on what's typed in the B column. My question is, if a cell in the B column is blank because the empl...
SergeiBaklan
Dec 31, 2018Diamond Contributor
If don't use predefined shift, however assume they have the same logic in names, that could be
=IFERROR(((MID(B3,SEARCH("-",B3)+1,LEN(B3)-SEARCH("-",B3)-1)&":00")+(MID(B3,SEARCH("-",B3)-1,1)<>RIGHT(B3,1))*0.5-(LEFT(B3,SEARCH("-",B3)-2) &":00"))*24-0.5,0)