Select & delete cells below a specific value

Question

I have a spreadsheet formatted as a table with a column of values formatted as hh.mm. It is calculated from 2 previous columns formatted as dd/mm/yyyy hh:mm. I want to delete all cells from the last column that have a value below 12.00. I can't get it to work through either conditional formatting or find &amp; replace. I guess this is to do with the number formats. What is the workaround?

hansvogelaar · Answer

Can you filter the column on value &lt; 12:00 or 0.5 ?
You can then select the filtered cells and clear them.

davehowell · Answer

Too easy! Thanks.&nbsp;

Forum Discussion

Select & delete cells below a specific value

2 Replies