Simply modifying the formula something like this
=IF(AND(MOD(D10,1)<MOD(D9,1),MOD(D10,1)MOD(D11,1) ),"do this","etcet")

basically if D9 is the upper bound and D11 lower bound and D10 is the value
you wish to compare


"drew.skis" wrote:

Thank you so very, very, very much! I would have never guessed.

I would like to learn more about using dates and times. Can you recommend a
resource (websites, online classes, books, etc.)? I'm already a fairly
skilled user, but want to know more about this particular area.

At the risk of taking advantage of your kindness, I have one more question:
how do I identify whether a given time is between two times? Same issue as
before - I have many dates and times involved, but the "between times" are
not date sensitive.

I will propose a toast to you, whoever and whereever you are, when my wife
and I do cocktails after works tonight!

Andrew
Seattle, WA

"N harkawat" wrote:

Say your date+time is in cell A1 and you want to compare it with data+time on
cell B1
something like this:
=if(mod(a1,1)mod(b1,1)...etc)


"drew.skis" wrote:

How do I identify whether a certain time of day, regardless of date, is
earlier than a fixed time of day (e.g. 11AM - date is not important)?