How Can I Have the Number of Hours between Two Date/Time Field Entries Calculated and Displayed?

  • Profile Image
    excalibur101
    Asked on March 27, 2015 at 06:50 PM
  • Profile Image
    excalibur101
    Answered on March 28, 2015 at 11:51 AM

    Thanks for your response. I didn't go any further than testing the link you supplied. When that calculation is done....it's wrong. For instance, if you input an eight hour period on a single date, the calculation says it's 7.92 hrs.  It's even off if you input a total of 30 minutes. 

    Any ideas?

  • Profile Image
    AlanJordan
    Answered on March 28, 2015 at 12:13 PM

    I see the same issue.  The result for a 30-minute time difference is .48, not .50 hours.

  • Profile Image
    abajan
    Answered on March 28, 2015 at 03:35 PM

    @excalibur101 and  AlanJordan

    Try this clone of my colleague's jotform. The expressions entered in its calculation fields are as follows:

    For the field labelled "Calculation" (hidden in my form) :


    For the "Hours" field:


    Of course, you're free to clone the form and examine it for yourselves.


    @AlanJordan

    Please open a separate thread if you need to discuss this further. (We've found it's better to deal with each user in their own thread.)

    Thanks

  • Profile Image
    TycenDemolitions
    Answered on March 16, 2016 at 07:50 AM

    Excellent solution abajan ! works great for me! thanks.

     

  • Profile Image
    mert
    Answered on March 16, 2016 at 09:09 AM

    On behalf of my colleagues, you are most welcome. I hope everyone in this thread will be satisfied with the answer. Please, do let us know for further information.

     

    Best regards.