I need to auto-fill time in a column while adding 15 mins.

  • Lee_Walter
    Answered on July 01, 2021 11:46 PM

    I need to auto-fill time in a column while adding 15 mins. So when 1st row is entered with time in decimal (ex. 2.57) second and rest will auto-fill the entire column.

    1. 2.57

    2. 3.12

    3. 3.27

    4. 3.42


  • Ariel JotForm Support
    Answered on July 02, 2021 07:44 AM


    I'm a little confused with your set there. You've said 15 minutes but in your example, the difference between your first number 2.57hrs (02:34:12) and the second number 3.12hrs (03:07:12) is 33 minutes.

    15 minutes is 0.25 in decimals (15/60), so you only need to add 0.25 to the first number, and so on. I.e.:

    1. 2.57
    2. 2.82
    3. 3.07
    4. ...

    Or, did I misunderstood your question? If that's the case, can you add more detail regarding your concern?

    Please share the URL of the form you're working on for us to better assist you. You can also send us screenshots to better illustrate the issue.

    Anyway, if you need to perform calculations on your form, you could either use the Form Calculation widget or Conditional Logic's Update/Calculate Field.

    If you need further assistance, please feel free to contact us.

  • Lee_Walter
    Answered on July 06, 2021 03:25 PM


    Thank you for your quick response. Here is the link to the form - https://form.jotform.com/211815099962161

    I would like to use "time" column to represent time information, but the table doesn't support time format as far as I know. So I would like to use decimal to represent time. In the first row user will enter actual time - 2.17 (same as 2:17). Then rest of the column will be filled automatically with each row adding 15 minutes to the previous number.

    Example -

    2.17 (user entered)

    2.32 (auto-filled)

    2.47 (auto-filled)

    3.02 (auto-filled)

  • Jed_C
    Answered on July 06, 2021 09:29 PM

    It's possible, but you will create multiple conditions for each cells where you want to autofill the time. In my sample screencast below, I made 4 rows on Time column to fill when you put a value in the very first cell in Time column.

    1625621088 60e5026027a96 table Screenshot 10

    1625621123 60e5028328c54 The Easiest Onl Screenshot 21

    However, once you have reserved the cell with a condition, you can no longer use that cell with other condition as it will cause some conflict. If the user will always put the value on 1st cell in Time column, then that would be predictable with your condition. The condition won't work if don't know where cell the users will put the time.

    If that's the case, it won't work with the input table, you'll have to create an individual field for that, then create your own custom calculation.

    I hope that clarifies it, but let us know if you have any questions.

  • Lee_Walter
    Answered on July 08, 2021 05:03 PM

    Thank you for your quick response. However what I'm looking for is to adding 15 minutes to the time. But what you are doing is just adding .15 to the initial value. It doesn't work when minute value goes over 60. For example, if initial value is 2.57 then next number is 2.72 but what I want is 3.12; so it should round up to next hour. Please help!

  • Jed_C
    Answered on July 08, 2021 08:34 PM

    Please allow me some time to check on what formula is needed to increment the minutes. I'll let you know here once I have a solution.

  • Lee_Walter
    Answered on July 15, 2021 03:42 PM

    Any update?

  • Jed_C
    Answered on July 15, 2021 06:58 PM

    Unfortunately, I'm unable to find a solution for this. Jotform doesn't have a math function that detects the number as a time. It only converts it in epoch time.

    1626389478 60f0bbe679152 The Easiest Onl Screenshot 10

    I've also tried it with a time property field, even the time field doesn't recognize the incremented number.