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

  • MaidCrew
    Asked on March 28, 2016 at 1: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

  • Mike
    Replied on March 28, 2016 at 4:38 PM

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

    round(number/10)*10

    Converting / Rounding value up or down to nearest 10 min mark Image 1 Screenshot 20

    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.

  • MaidCrew
    Replied on April 2, 2016 at 3: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"

  • jonathan
    Replied on April 2, 2016 at 8:25 PM

    I test on your form https://form.jotform.com/60875620033148 but it seems it was working as described already

    Converting / Rounding value up or down to nearest 10 min mark Image 1 Screenshot 30

     

    Converting / Rounding value up or down to nearest 10 min mark Image 2 Screenshot 41

     

    there was on no 00mins anymore for the whole hour number...

    Please describe more if this was not what you meant.

    Thanks.