JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can field auto calculate?Asked by TracyMoralee on January 07, 2016 at 04:57 PM
I am creating a form to use for employees to enter their time worked like a timesheet. Is there a way to have the form auto calculate the total number of hours worked? I have a field where they add their start time, a field to enter their end time and then another field where they select whether they took a 30 min, 45 minute or 1 hour lunch or none.
PS I am using the 24 hour clock
Yes, form calculation is possible. Here's a guide for that: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form
If you need further help, let us know.
Thank you! I will try that!
Feel free to let us know if you need further assistance.
I have added the equation using a form calculation widget and it is not calculating. I am not sure what I am doing wrong.
It looks like there's a problem with the formula. Once the user selects the 30 minute or 45 minute option, the formula subtracts it by either 30 or 45.
It also looks like the calculation values for the options are empty. Y
You can check the calculation value by clicking on the gear icon then select Edit Properties.
Then to fix the formula, add these values to the calculation field:
Do inform us if you need further assistance,