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.


  • Profile Image

    Converting / Rounding value up or down to nearest 10 min mark

    Asked by MaidCrew on March 28, 2016 at 01:29 PM

    https://form.jotform.com/60875620033148 

    Hello... on this form I've got a decimal based field that ends up converting a time equivalent.

    Example: 4.38

    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)

    Shawn

    Page URL:
    https://form.jotform.com/60875620033148

    hours round number convert hour
  • Profile Image
    JotForm Support

    Answered by Mike on March 28, 2016 at 04:38 PM

    In order to round the number to 10, it is possible to use the next formula:

    round(number/10)*10

    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.

  • Profile Image

    Answered by MaidCrew on April 02, 2016 at 03:53 PM

    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"

  • Profile Image
    JotForm Support

    Answered by jonathan on April 02, 2016 at 08:25 PM

    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.

    Thanks.