Hi

I have used formula =d2-c2-7.5/24.

I have draged this formula downward, unfortunatley in colum c where there is no value formula cell shows #######.

Please advice what amendment is should use if colum c has no value then formula cell stays blank.

I know for vlookup i use =if(iserror(???????????????).

please advice.

Regards