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

  • Profile Image
    Lee_Walter
    Asked on July 01, 2021 at 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

    etc.



    This is a re-post of a comment on Mastering Date and Time Calculation

  • Profile Image
    Ariel_P
    Answered on July 02, 2021 at 07:44 AM

    Greetings,

    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.

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

    Ariel,


    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)

  • Profile Image
    Jed_C
    Answered on July 06, 2021 at 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.gif

    1625621123_60e5028328c54_The Easiest Onl

    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.

  • Profile Image
    Jed_C
    Answered on July 08, 2021 at 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.

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

    Any update?

  • Profile Image
    Jed_C
    Answered on July 15, 2021 at 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

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