What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How do I make my form do calculations on 2 fields (start time: hh:mm:ss) and end time (hh:mm:ss) and have the total displayed in seconds?Asked by luaijaffal on July 26, 2015 at 02:07 PM
it is about a media monitoring project where we need to calculate the time dedicated to each candidate in seconds!
1) Add the Date Time fields, enable the Time option.
2) Add the Form Calculation widget(In this case I added two in order to show results in days and in seconds)
3) On the calculation widget, perform this calculation:
If you want it in days, simply remove the 86400.
Please try my form here: http://form.jotform.co/form/52064996724869
You may clone my form to inspect further: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
Let us know if you need more help, we will be glad to assist you.
Thank you very much BDAVID! Very much appreciated your help! However my concern is about the date time field i would need to show the seconds field....for example start time: 14:22:32 end time:14:24:45 so the total time shoul show 133 seconds.
As said befor it is about media monitoring project during election campaigne! So seconds is very important to do a proper and fair calculatin.
Thank you again and hope there is away to do that!
Sent from my Samsung device
Unfortunately, DateTime field and other Time fields doesn't have Seconds property on them. So, there is no means to show the seconds time on the DateTime field itself.
The solution provided by our colleague BDavid does show time calculations in seconds between 2 time.
But perhaps an additional display of time up to seconds is all you need to add on your form so that the end user will be aware of the ticking time in seconds as well.
How about adding the Countdown widget into the form also. It will allow the end user have a visual cue as to how many seconds had already tick on.
It can complement the solution by BDavid that shows the calculated total time in seconds.
Here is the demo form that have a Countdown widget on it http://form.jotformpro.com/form/43440585745965
Hope this help. Let us know how we can be of further assistance.