How we can calculate the time difference in total minutes

Hi

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

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

Is that something possible,

Thanks

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.

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.

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

Formula: (End Time - Start Time)*60

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

Do get back to us if you have any questions.

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,

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.

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:

It should now look like this:

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