Forum Discussion
Solved
My formula will not ignore Text in a drop down function
I am trying to make a staff roster and have a drop down menu that has time values and word values that can be selected. The cell that the menu exists in, is part of a formula, calculating total hours...
Try putting this formula in E8 and dragging down to E16:
=IFERROR(D8-C8,"")
That worked perfectly, thank you so much for the fast response :) :) :) !!!
You're welcome. If you need to identify Text vs Numbers in the future you can always use these two functions:
ISTEXT() or ISNUMBER()
Hi Matt,
I also need to subtract half an hour from this formula (I have just found out). I have tried putting in -"00:30" but because I don't quite understand the formula you gave me (but it works, so yay!) I wasn't sure how to incorporate the -"00:30". Could you please show me how I would type it to subtract half an hour if you knew how to do that?
Sorry for the late reply. I seemed to miss your latest post.
Try this formula:
=IFERROR(D8-C8-"00:30","")