Please Help - date/hour conditions

[Rimantas]

Hello,
I watching youtube and Excel documentation, but there are just simple examples which I cant relate to my project.
I dont understand what kind syntax must be used in order to sort dates with hours.

Example:
Every day I need to sort dates with hours. Format 3/24/2020 0:00 in the cell. and i need to make condition which shows:
Mark dates which are older now()-1 and of that last oldest day hour 8:00
.
today is 3/21/2020 11:58
show and mark me:
3/20/2020 9:01 - do not mark
3/19/2020 7:58 - this date SHOULD be selected and marked, because it is less than 8:00 AM
3/19/2020 8:01 - this date should NOT be selected and marked, because it is good time from 8:00 AM
3/18/2020 9:01 - mark this one because it is older

 

[jasonb75]

You don't say how you want to 'Mark' the entries, but as a logical test, to return TRUE for the second and fourth conditions in your list, or FALSE for the first and third:-

=OR(MOD(A2,1)<("08:00:00"+0),A2=MAXIFS(A:A,A:A,">="&INT(A2),A:A,"<"&INT(A2+1)))

Assumed data in column A, first record in A2.

 

[Fluff]

Cross posted Please Help - date/hour conditions

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.