Note that when you say greater than 29, XL takes that to mean 29 DAYS. For
instance, if you input 1:23 into XL, that's actually a decimal number of
about 0.058

So, for OP, if your wanting to find a difference of 29 HOURS, adjust your
formula to be

=(D5-B5)*14401.208
and
=(D5-B5)*1440<-1.208
--
Best Regards,

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


"xlmate" wrote:

Hi

I am not sure how you can arrive ot < 29 if you formatted into h:mm
the maximum for a day is 24hrs.

Would you provide a sample data table and your expected result

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"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