Request for Assistance: Setting Conditions and Calculating Duration in ZOHO CREATOR

Request for Assistance: Setting Conditions and Calculating Duration in ZOHO CREATOR


Hello ZOHO Creator Team,

I am currently working on a project using your platform, and one of the forms I've built includes two fields: Working start Time and working end Time , I would like to set a condition that prevents the user from inputting a Start Time that occurs after the End Time , My goal is to prevent the input of erroneous data , How can I implement such a condition?

Additionally, I'm interested in calculating the duration of work, finding the difference between the two times including hours, minutes, and seconds. How can I create such a calculation field (in total working hours field)?

Your guidance on these matters would be greatly appreciated.

Thank you .