Calculation issue

  • zehrabatool
    Asked on June 3, 2017 at 4:21 AM

    In my form, I want if total minutes is more then 60 minutes then it add 1 hour is total hours.

    How can i achieve this?

    Jotform Thread 1162399 Screenshot
  • BJoanna
    Replied on June 3, 2017 at 5:56 AM

    To achieve that you will have to add one additional calculation field to your form and to use floor Math function. You can set your calculation like this. 

    Calculation issue Image 1 Screenshot 40

    Form Calculation - Math Function Reference

    For minutes you will have to also add one additional field and you will have to use Update/calculate conditional logic. You will need to create multiple conditions, for each time range. On my demo form I have set conditions like this. 

    Calculation issue Image 2 Screenshot 51

    This is an example how calculation will work. 

    Calculation issue Image 3 Screenshot 62

    Here is my demo form: https://form.jotformpro.com/71532353957966 

    Feel free to test it and clone it

     

    Hope this will help. Let us know if you need further assistance.