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.
Converting / Rounding value up or down to nearest 10 min markAsked by MaidCrew on March 28, 2016 at 01:29 PM
Hello... on this form I've got a decimal based field that ends up converting a time equivalent.
It's converted to show "4 hrs, 23 mins"
How would I be able to adjust/calculate either the decimal or the converted mins to that the minutes round to the nearest 10 minute mark?
In the above example... the formula would allow the output to show "4 hrs, 20 mins" rather than "4 hrs, 23 mins"
Thanks in advance. (this one looks pretty complicated)
hours round number convert hour
In order to round the number to 10, it is possible to use the next formula:
Please try to apply this on your form. If you need any other assistance on this, let us know so we will be able to look further.
Hello again... hoping to get help understanding how to round up or down to the nearest hour. I've gotten my form to round to the nearest 10 minute mark but if it's 4-5 minutes to the nearest hour, I'll get...
Example: 4hrs, 00mins or 5hrs, 60mins.
Can someone show me how to get rid of the 00mins so that it rounds down to just "4hrs" and to get rid of the 60mins and then have the hour tick up by one hour.
Thanks in Advance
By the way... I'm not needing the output to conform to either 12 or 24 hour AM/PM format... I'm merely looking to render total hours/mins ... so hypothetically, the hours could end up tallying to 29hrs, 30mins....
The ultimate goal is to render the tallied hours/mins result, based on the number of service members on the team as:
"29hrs, 30mins with 1 person"
"14hrs, 50mins with 2 people"
"9hrs, 30mins with 3 people"
I test on your form https://form.jotform.com/60875620033148 but it seems it was working as described already
there was on no 00mins anymore for the whole hour number...
Please describe more if this was not what you meant.