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

  • Profile Image
    Asked 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.

    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)


  • Profile Image
    Answered on March 28, 2016 at 04:38 PM

    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.

  • Profile Image
    Answered 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
    Answered on April 02, 2016 at 08:25 PM

    I test on your form 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.