How to Run workflow based on a time range

Amr

I have a sheet where data comes through Forms.So I need the rows added from 9:30 AM-5:30 PM to be marked Valid.But my Workflow doesn't work.

Time.png

Valid Workflow.png

Paul Newcome

Try a formula instead:

=IF(AND(VALUE(SUBSTITUTE(Time@row, ":", "")) >= 930, VALUE(SUBSTITUTE(Time@row, ":", "")) <= 1730), "Valid", "Invalid")

Paul Newcome

Try a formula instead:

=IF(AND(VALUE(SUBSTITUTE(Time@row, ":", "")) >= 930, VALUE(SUBSTITUTE(Time@row, ":", "")) <= 1730), "Valid", "Invalid")

Amr

Thank you Paul.It worked!

Paul Newcome

Happy to help. 👍️

Amr

Hi @Paul Newcome

Can I get the same formula that references the Created column instead of the Time column? My Time column keeps changing whereas the Created column is static and doesn't change once set.

created.png