Try:

=AND(COUNTIF(E15,"*R*"),TIMEVALUE(G15)TIME(8,30,0 ))

In article ,
mndpy wrote:

One more question what is the G15 is a subtraction of time however it is just
a gerneral text format?

"JE McGimpsey" wrote:

One way:

CF1: =AND(COUNTIF(E15,"*R*"),G15TIME(8,30,0))
Format1: <patterns/<desired color