I have inherited a spreadsheet that uses conditional formatting to show by
color when a time is a little over and a lot over. Some how they converted
the time to a decimal point, but it does'nt make sense. Unfortunately, it
does'nt seem to transfer from different pages in the workbook from 7:00 to
8:00.

Cell is Formatted as Custom h:mm

Conditional Formatting for 7:00 am

Cell Value is between 0.313194444444444 and 0.319444444444444

Cell Value is greater than 0.319444444444444


Conditional Formatting for 8:00 am

Cell Value is between 0.417361111111111 and 0.423611111111111

Cell Value is greater than 0.423611111111111


Any help on how to make hours & minutes work to show if someone is late
would be greatly appreciated.