Can field auto calculate?

  • TracyMoralee
    Asked on January 7, 2016 at 4: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. 

     

    Thank you!

     

    PS I am using the 24 hour clock

    Jotform Thread 739145 Screenshot
  • Elton Support Team Lead
    Replied on January 7, 2016 at 10:56 PM

    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.

  • TracyMoralee
    Replied on January 8, 2016 at 1:28 AM

    Thank you! I will try that!

  • Elton Support Team Lead
    Replied on January 8, 2016 at 2:37 AM

    Great!

    Feel free to let us know if you need further assistance.

    Regards!

  • Jeanette
    Replied on January 11, 2016 at 4:13 PM

    Hello,

     

    I have added the equation using a form calculation widget and it is not calculating. I am not sure what I am doing wrong.

     

    Thank you!

  • Chriistian Jotform Support
    Replied on January 11, 2016 at 11:24 PM

    Hi,

     

    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.

    Can field auto calculate? Image 1 Screenshot 50

    It also looks like the calculation values for the options are empty. Y

    Can field auto calculate? Image 2 Screenshot 61

     

    You can check the calculation value by clicking on the gear icon then select Edit Properties.

    Can field auto calculate? Image 3 Screenshot 72

     

    Then to fix the formula, add these values to the calculation field: 

    Can field auto calculate? Image 4 Screenshot 83

     

     

     

    Do inform us if you need further assistance,
    Regards.