Minutes and seconds calculation

Hello,

Is it possible to run calculations in a [minutes : seconds] format? I'm trying to also deduct and add seconds depending on if criteria is met or missed while timing employees performing certain tasks. I appreciate the help!

Thank you,

Scott

Hi Scott,

There's no direct solution for that, but you can achieve that using out Form Calculation widget:

https://www.jotform.com/widgets/calculation

https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget

You can perform minutes: seconds calculation based on the seconds' amount and using following formulas extract minutes and seconds:

for instance, you have time in seconds X seconds.

for minutes you can use the formula: seconds / 60

for remaining second, use the formula: seconds - (minutes * 60)

Here's the demo form below:

https://form.jotform.com/202956256842058

Then, of course, you will be able to add or subtract the desired amount of seconds, to your initial seconds.

You can also clone it on your account:

https://www.jotform.com/help/42-how-to-clone-an-existing-form-from-a-url

Please check and let us know if you have any further questions.

Thank you!