Hello, I am working on an attendance spreadsheet and would like to highlight when someone has been late by 15 minutes. The problem is that the values stored are stored in this format "dddd-mmmm-dd-yyyy h:mm AM/PM" so that gives me a decimal number of 43833.29167 for friday at 7:00 AM. 15 minutes after that comes to 43833.30208. Is there a way for conditional formatting to ignore all the number to the left of the decimal point, IE XXXXX.30208. Any help on this would be appreciated.

Thank You
-Max