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
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