Cell is showing negative calculation even if cells are not filled.

Hi,

In my spreadsheet I am calculating time minus break. I have drop down list to choose start time and end time and drop down list for breaks where the formula for breaks only is if its 15 minutes then value is 0 if 30 minutes then its .5.

The problem I'm getting is, the days that are not yet filled is showing a negative total.

I tried to combine some IF statements with ISBLANK but can't get around it.

Any suggestions please? Please see my sample workbook.

Thank you very much in advance.

Hi Glenn,

Thank you very much for the help. It is working but there are some cells that is not working though the formula is in place and the cell range is correct.

Columns C3, I3, and O3 is not working. When I change the the option either 15 or 30 from the drop down list the result doesn't change.

Any thoughts please?

Thank you.

Hi John,

I checked all the formula carefully and all is ok but it's not working. I wonder if this is a glitch on an excel using on a Mac.

Otherwise, I'm happy with the formula I would probably just redo the other columns that doesn't work.

Thanks to you both.