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 .