If I have nothing in my E or F column, the cells in G show a "0", where the formula below is. How can I correct this so the cells in G show blank if nothing is in E or F?
=(TEXT(F4,"00\:00")-TEXT(E4,"00\:00"))*24
The same thing with the formula below. D2 is a static number (20%). If I have nothing in some of the cells in the C column, how can I get the result in D to be blank instead of showing "0"?
=SUM(C4 * 6.5)*($D$2)
Thanks for any help.
=(TEXT(F4,"00\:00")-TEXT(E4,"00\:00"))*24
The same thing with the formula below. D2 is a static number (20%). If I have nothing in some of the cells in the C column, how can I get the result in D to be blank instead of showing "0"?
=SUM(C4 * 6.5)*($D$2)
Thanks for any help.