Calculate the time difference

  • MD HAIRUDIN BIN SABUDIN
    Asked on August 20, 2023 at 10:24 AM

    How to create a basic hh:mm-hh:mm=hh:mm

    different of STD (Standard Time of Departure (hh:mm) minus STA (Standard Time Arrival (hh:mm) with result in hh:mm (durations of flight).

    Example

    STD-STA 15:00-1530=00:30 (00hr 30 mins)

    STD-STA 15:00-1630=00:30 (01hr 30 mins)

    Thanks/Rgds

    Page URL: https://www.jotform.com/help/tables-advanced-formula-operators/
  • Carrissa_M
    Replied on August 20, 2023 at 10:32 AM

    Hi MD HAIRUDIN BIN SABUDIN,

    Thanks for reaching out to Jotform Support. You can try using the Time field, let me show you how to set it up to do this calculation automatically. Let's go through it:

    1. Open the form in Form Builder.
    2. Find and select the Time field.
    3. Click on the Gear icon to open the Properties.
    4. Click on Range and enable the options Time Range and Duration Indicator.

    1663086411 6320af4bf1686 Screenshot 10 Screenshot 10

    Feel free to reach out again if you have any questions or if we can help you in any other way.