Calculation issue

  • Profile Image
    zehrabatool
    Asked on June 03, 2017 at 04: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?

  • Profile Image
    BJoanna
    Answered on June 03, 2017 at 05: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. 

    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. 

    This is an example how calculation will work. 

    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.