Thanks for responding. Still is not working so here is a further explanation.

Current Time is 6:20 AM and Previous Time is 5:44 AM. In this scenario, the
current time is <=-29 minutes after the previous time, so I want to shad the
previous time blue. Another scenario, current time 6:20 AM, previous time
6:51 AM. In this case the current time is =29 minutes before the previous
time and shad will be red.

I have tried to convert the times into minutes (D5-B5)*1440=29. This works
inconsistently. I can manually look at the times and shad them but I am
trying to automate as much as possible.

Thanks again and appreciate any help.
--
Mike


"Luke M" wrote:

Based on your statements, change your comparison symbols.

Condition 1 Formula is where D5 is the previous release time and B5 is the
current.
=(D5-B5)*1440=29
Condition 2 Formula is where D5 is the previous release time and B5 is the
current.
=(D5-B5)*1440<=-29

I'm also assuming you meant to shade the cell red when its -29 or LESS, not
greater.

If this isn't what you were looking for, could you explain more what is
going wrong?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mike" wrote:

I need to compare a current production release time (that will vary between
regions) to previous months release times by region.
If the difference is 29 or greater shad the cell blue.
If the difference is -29 or greater shad the cell red.

I have tried these approaches in the but get inconsisted results.
Condition 1 Formula is where D5 is the previous release time and B5 is the
current.
=(D5-B5)*144029
Condition 2 Formula is where D5 is the previous release time and B5 is the
current.
=(D5-B5)*1440<-29

The cells are formatted h:mm AM/PM and I need to keep this format for
reporting purposes.

Appreciate any help.

Thanks,

--
Mike