How to calculate the total of different time fields and use it in calculation?

  • jacqgems
    Asked on May 29, 2019 at 6:26 AM

    Hi, How do I use the calculated time duration from the time field as the basis for my form calculation field? Currently, If I select the time field for calculation in the form calculation widget it gives me a response of zero. But I would like to add all the days' durations to give me a weekly total I can use to calculate my weekly rate. How can I make this possible, please on page 5?

  • AndrewHag
    Replied on May 29, 2019 at 9:14 AM

    If I understood your question correctly, do you wish to calculate the total time of the 3 time fields in the screenshot below and multiply the total sum with 3600?

    1559135574chrome b85XA9OrLV Screenshot 10

    To achieve that you can just add the below formula in the calculation widget.

    1559135635chrome R9vqq7qegP Screenshot 21

    Let us know if you need any further assistance.


  • jacqgems
    Replied on May 29, 2019 at 9:47 AM

    Hi on the Monday example, I used the 24-hour clock so that the duration would be calculated. I need to add the durations from what will be the 5 days of the week and use this for my calculation- Selecting Monday 0-9 currently gives a return of zero, I cannot figure out how to access the calculated duration field so that I can use it? Is this something that can be done?

  • Richie JotForm Support
    Replied on May 29, 2019 at 11:53 AM

    To clarify, do you want to calculate your time field?

    I have checked your form and it seems the calculation work correctly.

    How to calculate the total of different time fields and use it in calculation? Image 1 Screenshot 20

    Can you please explain further how you want to calculate the time field with your form?

    You may check this guide for more information in calculating date and time :https://www.jotform.com/help/443-Mastering-Date-and-Time-Calculation