Constraint - Comparing two "time" questions

Hello everyone,

I am currently trying to implement a constraint on a form that has two time variables (opening & closing hour). I would simply like to have a constraint on the closing hour so that it can't be earlier than the opening hour.

I have tried several lines in the "constraint" cell in the Excel file but can't get it to work properly.

Do you know which constraint should I write in order to achieve this result ?

Thank you very much in advance,

Hi @guillaume.pottier
you can use this example:
timeConstraintTes.xlsx (9.8 KB)

Let me know if it solves your problem.

Regards,
Grzegorz

4 Likes

Hi @Grzesiek2010, I was searching for a solution to a similar problem and I am glad I bumped into this response.

I can confirm that this solves the problem.

Thank you,
Dan

1 Like