I have a column that accepts dates (8/14/07). some of the cells don't have
any dates cause there is no need. I am trying to use an if statement
referring to this column to perform a mathematical function. what i have is
=IF(C7=C6,SUM(Z7-Z6),""). If works fine but when both cells are blank it
returns a time of 0:00 and i want it to return a blank cell, the same as it
would if it was false. i've tried AND and OR and cannot figure out how to do
it correctly. Can someone help me?

The Z cells are formatted for time as is the cell the result is going into.