S
Seanie
How could I check if a Time value falls between two other time values?
I want to essentially establish if a premises is open or not at
various times of the day.
My time values are input as hh:mm and have no date. The issue I am
having is that opening times can vary, which may include past 12:00am
eg. 7:00am to 2:00am (the following day). So if I check if the
premises is open during the hour 11:00pm I can construct a formula
test if it is >= than Opening time and <= Closing time, but this won't
work past 12:00am (see CF below)
Do I need to combine a dd aspect to the hh:mm values and if so how
could I do that?
Ultimately what I want to do is change the background colour of the
Time value to Blue
A previous post offered the following CF =AND(A8>=Sheet2!F7,A8<=Sheet2!
H7), but that doesn't get me past 12:00am
A8= Time
F7 = Opening Time
H7= Closing Time
I do have dates of the week referenced in C1:C7
I want to essentially establish if a premises is open or not at
various times of the day.
My time values are input as hh:mm and have no date. The issue I am
having is that opening times can vary, which may include past 12:00am
eg. 7:00am to 2:00am (the following day). So if I check if the
premises is open during the hour 11:00pm I can construct a formula
test if it is >= than Opening time and <= Closing time, but this won't
work past 12:00am (see CF below)
Do I need to combine a dd aspect to the hh:mm values and if so how
could I do that?
Ultimately what I want to do is change the background colour of the
Time value to Blue
A previous post offered the following CF =AND(A8>=Sheet2!F7,A8<=Sheet2!
H7), but that doesn't get me past 12:00am
A8= Time
F7 = Opening Time
H7= Closing Time
I do have dates of the week referenced in C1:C7