Conditional formatting based on time

[dljjackson]

I'm trying to conditionally format a row based on if the time in column R exceeds an hour. I calculated column R with formula M2-P2 but M and P are two columns with time in different formats. The calculated times in column R appear correct but aren't formatting correctly based on my conditional formatting formula where I'm attempting to fill the row red if R2>TIME(0,59,59). I've also tried R2>(1/24). With both formulas every line is filled even the lines that are obviously less than 1 hour. Images attached. Any assistance would be greatly appreciated.

 

[Fluff]

@ExceLoki The OP's data contains a date & time, not just time.

 

[ExceLoki]

@ExceLoki The OP's data contains a date & time, not just time.

i formatted both M & P columns as time only. the dates are in a separate column. that should fix the return value in R

 

[Fluff]

Cell formatting has nothing to do with it, your cells A & D only contain a time element, whereas the OP's data also contains a date, therefore your suggestion will not work without some tweaking.