create a filter/checkbox to identify rows created after 12:00Pm

Joseph Aloysias

I would like to create a filter/checkbox to get the rows created after 12:00PM to 5:00 PM same day.

Is there a way we can do this?

Paul Newcome

Ok. So just between the hours of noon and 5pm get checked then?

In that case you would use something like this:

=IF(AND(OR(VALUE(SUBSTITUTE(MID([Requested On]@row, FIND(" ", [Requested On]@row) + 1, 2), ":", ""))<=5, VALUE(SUBSTITUTE(MID([Requested On]@row, FIND(" ", [Requested On]@row) + 1, 2), ":", "")) = 12), FIND("PM", [Requested On]@row)>0), 1)

Paul Newcome

What if it was created after 5pm? Would you want that checked as well, or are you just looking to check the boxes on rows that are between noon and 5pm?

Joseph Aloysias

the unchecked rows would be calculated if its created after 5pm

Paul Newcome

Ok. So just between the hours of noon and 5pm get checked then?

In that case you would use something like this:

=IF(AND(OR(VALUE(SUBSTITUTE(MID([Requested On]@row, FIND(" ", [Requested On]@row) + 1, 2), ":", ""))<=5, VALUE(SUBSTITUTE(MID([Requested On]@row, FIND(" ", [Requested On]@row) + 1, 2), ":", "")) = 12), FIND("PM", [Requested On]@row)>0), 1)

Joseph Aloysias

@Paul Newcome Thank you so much

Paul Newcome

Happy to help. 👍️