I have a Google sheet that has a column for "last updated" and each row represents a separate file. People manually paste in the time and date in that column, like in the screenshot. 
 
If the date and time *is not* within the last 24 hours, then I want that cell to turn red. The "date is before" option only checks the date and not the time.

For this example, let's say the current time is 930 AM, so the cells that have a time *before* 9:30 AM yesterday should turn red. The cells that have a time *after* 9:30 AM yesterday should remain unaffected. 

This is what I want it to look like.

[![This is what I want it to look like][1]][1]

How can I do this with Google Sheets conditional formatting?

Here is my test sheet. 

[![enter image description here][2]][2]  
<sup>(Click image to enlarge)</sup>   


  [1]: https://i.sstatic.net/ZhqWP.png
  [2]: https://i.sstatic.net/T1kZx.png