Excel's checkbox tool helps ... will remain blank: =IFERROR(SUM([@[End Time]]-[@[Start Time]]),"") Again, once I press Enter, the formula will be applied to all rows in that column.