Why is my calculation coming out funny.

  • AENYtrav
    Asked on July 1, 2014 at 3:43 PM

    I am fine with the 24 hour clock. I also followed the calculation steps here: http://www.jotform.com/answers/395948-Hour-Minute-Calculator. My imput will be 2:20 and 5:40, I will get a result of 3.33,  when its only 20 minutes and should be expressed as 2.20. What am I missing here? See example 10 is coming out as .17.

     

    Jotform Thread 398431 Screenshot
  • David JotForm Support
    Replied on July 1, 2014 at 5:04 PM

    Hi,

    The output is expressed as a decimal number, not as an expression of time.  So when there was a 3hr and 20min difference, that was 3 and 1/3 of and hour or 3.33.  The image you posted is a 15hr and 10min difference, or 15 and 10/60 or and hour or 15.166666667 which was rounded to 15.17.  Please let us know if there is anything else we can assist you with and we will be happy to help.

    Thank you for using Jotform!

  • AENYtrav
    Replied on July 2, 2014 at 10:05 AM

    Thanks! I really didn't think of it that way.

  • Jeanette JotForm Support
    Replied on July 2, 2014 at 11:50 AM

    I am very glad to see David's explanation worked out well for you.

    If you have any further unrelated question, please open a new thread and we will be happy to assist you.

    Cheers!