Hi guys,
I am currently using the following formula: =(C11-B11)*24-IF((C11-B11)*24>7,0.5,IF((C11-B11)*24>=5,0.5,0)) to return the calculation of hours between the two cells.
So if cell B11 contains 8:30 and cell C11 contains 16:30 then this will return the count of hours between these two cells as 7.50.
However if I enter any text in cell C11 or B11 then it returns an error. is there a way if I was to enter in the text as either AL, SL, DIL or PH it would still return the value 7.50. Then finally if the Cell was to contain the text RDO then it would ignore the text and return the value 0.
Any help is appreciated with this, as I don't fully know how to formulate this.
Cheers,
Marc
Bookmarks