Help with time formulas

[JennyGP]

Hello All -
I am trying to calcualte a time in and time out whether its <5 hours, Between 5 and 6 hours, or more than 6 hours


Example:
IN 5:05
OUT 12:13
<5 Hours = NO
Between 5 and 6 Hours = YES
> 5 Hours = YES

Please help.
Thank you so much in advance.
Jenny

[Richard Buttrey]

Hi,

Your Q. isn't clear. Assumimng Yes applies to anything > 5 hours then

Please Login or Register  to view this content.

[ConneXionLost]

Since you only seem to want a "YES" or "NO" response, how about:

Please Login or Register  to view this content.