Conditional Formatting Cells X amount of minutes to previous cell

[DominicKEX]

Hi Everyone.

I am trying to create a worksheet that highlights SLA acceptance and breaches.

In Column F, I have the time an Incident is received e.g. 16:05:00
In Column G, I have the time I accepted that incident e.g. 16:10:00

I need the cells in column G to highlight Green if it's within 15 minutes of cells in Column F - Highlight Red if it's over 15 Minutes.


I've been pretty good with conditional formatting but the time aspect is proving difficult.

Thanks!!

 

[yky]

Set these two conditions:

=(G1-F1)*1440<=15
=(G1-F1)*1440>15