How we can calculate the time difference in total minutes

  • Profile Image
    Carrapateena
    Asked on August 05, 2022 at 11:08 PM

    Hi

    how we can calculate the time difference between the start and stop time in total minutes in a separate tab.


    1659755241_62eddae9c88c8_

    1659755265_62eddb019e432_

    I want this 23.53 in total minutes as 1433 minutes in seperate column,


    Is that something possible,


    Thanks

  • Profile Image
    Cecile
    Answered on August 05, 2022 at 11:20 PM

    Hello Carrapateena,

    Thanks for reaching out to Jotform Support.

    Please allow me some time to check on this and get back to you with relevant information.

  • Profile Image
    Cecile
    Answered on August 06, 2022 at 12:29 AM

    Thanks for waiting.

    I did some tests but I cannot seem to achieve your requirement using Time Range. As a workaround, you might consider using 2 time fields in 24hr format.

    1659759962_62eded5a16b14_15.png

    Then, add a form calculation widget to get the time difference in minutes.

    Formula: (End Time - Start Time)*60

    1659760016_62eded90baa66_16.png

    Demo: https://form.jotform.com/222171112539043


    1659760087_62ededd7e88da_7.gif

    Do get back to us if you have any questions.

  • Profile Image
    Carrapateena
    Answered on August 06, 2022 at 12:55 AM

    Hi,


    Please find the screenshot below, if we would like to calculate the timing for pm start and am finish it goes negative,


    How we can rectify this,


    Thanks,


    1659761683_62edf41389120_

  • Profile Image
    Mary
    Answered on August 06, 2022 at 04:51 AM

    Hello Carrapateena,

    Please allow me some time to check for any workarounds, I will get back to you as soon as I have an update.

    Thank you for your patience.

  • Profile Image
    Mary
    Answered on August 08, 2022 at 08:12 AM

    Hello Carrapateena,

    Thank you for waiting. You can add another form calculation widget with the following formula to convert the negative value to a positive one:

    1659960696_62f0fd786b94e_

    It should now look like this:

    1659960708_62f0fd840618d_

    Give it a try and let us know if this works for you.